MySQL query that returns records that fall on or after date_modified + 7 Days
Posted on 2012-09-04
I'm trying to put together a MySQL query that returns records that fall on or after date_modified + 7 Days. After a bit of research this is what I came up with, but it isn't working correctly. All dates are DATETIME types.
FROM customer_production_status ps
WHERE (ps.email_message_id = '2' OR ps.email_message_id = '3')
AND (DATE_ADD(ps.date_modified,INTERVAL 7 DAY) >= NOW());