Ehmm...now I get the error that GetDate can't resolve. I'm using your exact syntax for the datediff statement. I saw that I used "dd" Instead of 'd' at first..so I changed that. But it still doesn't help.
It seems that within the SQL statement it can't resolve the SQL field if I use a CF Function. -Gel -----Original Message----- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
