Does anyone use DateAdd in ColdFusion before and tell me why I can not use
the return
value from DateAdd to compare with date field in a table?
My problem is:
----------------------------------------------------------------------------
<cfset endDate = DateAdd('d', 2, '#mon[1]#') >
and it does print out endDate as date, however,
when I use this return endDate to query a table with date type field, it
always
say Error Code 907 ( missing right parathise..),
Select * from tblMei where #endDate# < ship_date;
Thanks.
Mei
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists