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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2.
Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271867
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
