>>ewwwww access...
This has nothing to do with Access.
The problem is that formated dates should not be used in SQL, only CF
date values (which are automatically converted t ODBCdates by default),
or better use ODCDates.
Secondly, quotes should nor be used with dates in SQL
This should work:
<CFSET thirdletterdate = DateAdd("d", -7, get.expiration)>
<cfquery name="Getnow" datasource="trials">
Select * from trials_info
where expiration eq #CreateODBCDate(thirdletterdate)#
order by expiration desc
</cfquery>
This should work, provided expiration has been entered using CreateDBCDate.
If it was entered with a time value different from 00:00:00, the equality won't
work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:271914
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
