Or use CF's if you can't change the SQL. DateFormat(startDate, "ddmmyy") NEQ DateFormat(endDate, "ddmmyy")
Adrian Building a database of ColdFusion errors at http://cferror.org/ -----Original Message----- From: Azadi Saryev Sent: 13 November 2008 10:49 To: cf-talk Subject: Re: problem with cfif conditions on dates you will need to use your db's date/time functions to select only the DATE part of these fields and compare/output those. Azadi Saryev ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
