joined:June 10, 2011
Hi. I'm having a problem showing only the records which are 21 days or less from the date in which they are submitted.
This is my line of code at the end of a long sql query:
AND DATE_ADD(add_date, INTERVAL 21 DAY) <=current_date
However this is bringing up ONLY those records which are older than 21 days from the date submitted.
I need it to be the other way round, but don't know how to negate the code.
My Mysql database column is add_date and it is a datetime type.
Any help would be much appreciated.