Comparing 2 dates

[sitechooser]

Hi Everyone,

I need to compare 2 date fields in my MySQL database (date1 and date2) to see if they are more than 28 days apart.

Can anyone help with suggestions for the correct MySQL query?

Thanks very much indeed.

[AndrewGSW]

A little searching tells me:

PHP Code:

"SELECT stuff FROM my_table WHERE DATEDIFF(date2,date1) > 28"
//or 

"SELECT date1, date2, DATEDIFF(date2,date1) AS difference FROM my_table"
// extract into $row..
if (intvar($row['difference'], 10) > 28) {
    // do more stuff 


but I haven't tried them. See the docs.

[sitechooser]

Massive thank you, Sir! I will let you know how I get on with that

Edit: Worked like a dream! I shall remember you when I'm a millionaire!