[Resolved] Dates + MySQL

[furious5]

Can anyone help me out, I have some dates formatted within a mysql table formatted like so 2004-02-25.

I want to do a calculation of them based on today's date and work out if there is less than 7 days difference.

Anyone got any ideas? I have thought about using FROM_UNIXTIMESTAMP(). However I was wondering if anyone knows a better way to deal with date calculation expressly using MySQL as opposed to PHP's functions.

[devinemke]

have a look at this page, particularly the bit about the DATEDIFF() function.

[furious5]

That looks perfect, thank you for such a quick response.