Because you are looking at dates less than or equal to today? Jerry Johnson
>>> [EMAIL PROTECTED] 06/04/03 02:00PM >>> Any idea why this where clasue is bombing? The expDates in the database are 6/30/2003 and 7/1/2003, yet no records are returning. The MS-SQL datatype for the field is datetime. <cfquery name="getAnnouncements" datasource="#Request.DSN#"> SELECT * FROM Announcements WHERE Announcements.AnnouncementExpDate <= <cfqueryparam cfsqltype="cf_sql_date" value="#DateFormat(Now(),'m/d/yyyy')#"> ORDER BY Announcements.AnnouncementStartDate </cfquery> Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
