I think comparing as an ODBC Datetime variable (using the CreateODBCDateTime() function) should work. That way you know you're comparing apples to apples. I've done that a few times when I have fits with different date formats.
-----Original Message----- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 07, 2007 10:13 AM To: CF-Talk Subject: querying a date/time field I want to compare dates in my Access database. It is setup as a date/time field in Access as "expiration". I want to check whether the expiration date matches a cfset date. I tried every combination with or without quotes, single quotes, the = sign or EQ, but since I don't always do CF programming I'm stumped. The dates look like 00/00/0000 in the database. I get different errors such as: Syntax error (missing operator) in query expression 'expiration eq [03/04/2007]'. <CFSET thirdletterdate = #DateAdd("d", -7, get.expiration)#> <CFSET sevendayemail = #DateFormat(thirdletterdate, "mm-dd-yy")#> <cfquery name="Getnow" datasource="trials"> Select * from trials_info where expiration eq "#DateFormat(thirdletterdate, "mm/dd/yyyy")#" order by expiration desc </cfquery> Thanks. RO HWW ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
