Re: [ic] Difference in Dates

[Michael <suppressed>]

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
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users