If you have a lot of trouble with the datecompare, you could also use something like a mathmatical evaluation:
<cfif dateformat(date1,"yyyymmdd") eq dateformat(date2,"yyyymmdd")> Accomplishes roughly the same thing. s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > Not really sure what answer you are after, however, you > are aware that 1 = > date1 is greater than date2 > 0 = dates are equal > -1 = date1 is less than date2 > ----- Original Message ----- > From: "Double Down, Inc." <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, February 07, 2003 8:25 AM > Subject: DateCompare Question >> I have two dates. Once is an ODBC date only that is based >> on the now() > function. The other is an ODBC date only that comes from > an SQL datefield. > The values come out to be {d '2003-02-06'} when I output > them. The problem > is the value for the DateCompare is 1 instead of 0. Anyone > have any > suggestions on how to get this to work? >> >> TIA >> DDINC >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/cf_lists/index. > cfm?method=subscribe&forumid=4 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > This list and all House of Fusion resources hosted by > CFHosting.com. The place for dependable ColdFusion > Hosting. > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
