Ever hear the expression "can't see the forest for the trees..."? Story of my life... 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]
>>> [EMAIL PROTECTED] 6/4/2003 2:08:01 PM >>> 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5