I have two Product attributes
I want products with prebook_date greater than today's date & prebook_date less than release_date value.
I tried this code to get products which are presale_date greater than today_date
$today_date = date('Y-m-d H:i:s'); $collection = Mage::getModel('catalog/product')->getCollection(); $collection->addAttributeToFilter('prebook_date', array( 'from' => $today_date, 'date' => true, ));
Any suggestions how to get products which have
prebook_date > today_date AND prebook_date < release_date