[ic] Difference in Dates

[Michael]

Hi!

On Thu, Feb 27, 2003 at 07:42:38AM -0800, Grant wrote:
> I need to have an "if" block that checks if the current date is more than 7
> days later than a date in a database field.  I've looked at the time tag and
> I'm wondering what the best way to do this would be.  Any pointers would be
> much appreciated.  Thanks!

I ran into something similar and used SQL to get my results (MySQL)

SELECT * FROM tablename WHERE to_days(date_column) < (to_days(now()-7);

Or something like that...

Michael