[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