Delete if date is over X days

I am tring to find a way to query a mysql db based on the date stamp.

I need to select the number of rows where date is between today and "X" date.

Once I have the sum I need to delete any records that are older than "X" date.

Does anyone know how this can be done?

The only information I have found is on getting the date and converting it. Please help.

Thanks in advance.

John

DELETE FROM <table name>
WHERE date BETWEEN NOW() AND <your date>

if you are looking to delete things in the last 3 days (or any other timeframe) try:

DELETE FROM <table name>
WHERE date BETWEEN DATE_SUB(NOW(), INTERVAL 3 DAY) AND NOW()

hth.
p.

Thanks P.

The second part of the code works for the select query also and that is great.

DATE_SUB(NOW(), INTERVAL 3 DAY)

I have tested the DATE < DATE_SUB(NOW(), INTERVAL 3 DAY) and it displays the records that are older than 3 days.

your help is really appreciated.