Skip to main content
1 of 2
Dinesh Yadav
  • 6.5k
  • 2
  • 23
  • 50

Try this in your product collection

$currentDate = Mage::getModel('core/date')->gmtDate('Y-m-d H:i:s');
$plusOneMonth = date('Y-m-d', strtotime($currentDate . "+1 months"));

$collection = Mage::getModel('catalog/product')->getCollection();
$collection->addFieldToFilter('expiry_date', array('from' => $currentDate, 'to' => $plusOneMonth));
Dinesh Yadav
  • 6.5k
  • 2
  • 23
  • 50