[thelist] CF date comparison problem
Chris Silwedel
silverbeetle at ozemail.com.au
Fri Jan 12 20:51:31 CST 2001
hi again
> the trick here is to push the comparison to the date level, ignoring the
> time portion of it. depending on your database (i'm assuming you're using
> access), one way to do it would be to put a dateformat() on the now() to
> restrict to just the date. that would look like this:
>
> show.showdate >= DateFormat(Now())
yes Jeff, it is an Access database. i've tried a little bit with dateformat
and just tried the above line again and i get errors like this:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'DateFormat'
in expression.
any more thoughts?
thanks for your help...
chris
More information about the thelist
mailing list