I want to display orders that are in status pending 4 days after the creation date.
In sql this work with this =>
SELECT * FROM sales_flat_order where DATE_ADD(updated_at, INTERVAL 4 DAY) and status = pending;
But with orm in magento this not work why ?
$collection = Mage::getModel('sales/order')->getCollection() ->addFieldToFilter('status', 'pending') ->addFieldToFilter('updated_at', new Zend_Db_Expr("DATE_ADD('updated_at', INTERVAL 4 DAY)"));
that does not give me the result I expect from my sql query at the top.
Can you help me please