sql date add query

Need to show records which are within or upto 21 days from date submitted.

[ebanbury]

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.

[Tommybs]

Try
AND DATEDIFF(NOW(),add_date) < 21

[rocknbil]

I'd use date_sub instead. Same result, I think.

select * from table where add_date >= date_sub(now(), interval 21 day)