Why not wrap a dateFormat() around the two compared values? Adam.
> -----Original Message----- > From: Double Down, Inc. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 06, 2003 4:25 PM > To: CF-Talk > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
