> Shouldn't this be working? > 21 : where promotionalID = 85 AND DateReceived >= > #dateformat(FORM.start_date, "MM/DD/YYYY")# > 22 : AND DateReceived <= #dateformat(FORM.end_date, "MM/DD/YYYY")# > > 23 : </CFQUERY>
No. Though I am surprised its causing a syntax error. A better way to compare dates is to pass in a datetime object either with cfqueryparam or even createODBCDate(). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
