[thelist] CF date comparison problem

jeff jeff at members.evolt.org
Fri Jan 12 21:01:31 CST 2001


: From: Oliver Lineham
: > how exactly do you propose to use the
: > datecompare() function in a query?
: i had assumed he wanted to check a date within
: a page - after it had been pulled from the database
: - because he didn't write show.showdate >= #now()#

if that had been the case it would have been

show.showdate GTE Now()

cf doesn't use the usual comparison operators that most languages use.

there's also the possibility that he was trying to use the internal, access
specific, now() function of the database to retrieve the date as opposed to
the cf function now() to retrieve the date.



mailto:jeff at members.evolt.org

More information about the thelist mailing list