What does your query look like right now?
Also the 'd' in the datediff function lets the query know to use days. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:40 PM To: CF-Talk Subject: RE: Deleting items older than 7 days from today You know..if I use just plain SQL..how does it know if I mean 7 Days..7 Weeks..or 7 months?? -Gel -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED] Nope..that didn't work either. Still error resolving estarttime. -Gel -----Original Message----- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Ok, I think I've found it in my BOL docs...Try this: SELECT * FROM tblEvents WHERE DATEDIFF(d, estatetime, #DATEFORMAT(NOW())#) HTH ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
