Don't use CF for it, let the SQL do the work for you...
Just setup your SQL statement like this:
Select * FROM tblEvents
WHERE DateDiff("d", GETDATE(), estarttime) >= 7
(Sorry, I referenced NOW() last time...it should be GETDATE())
HTH,
Scott
> -----Original Message-----
> From: Angel Stewart [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 9:29 AM
> To: CF-Talk
> Subject: RE: Deleting items older than 7 days from today
>
>
> '#DateDiff('d',Now(),estarttime)#
>
>
>
> Error near line 17, column 9.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
