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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
