Error (3085) with Date() function
Posted on 2000-01-07
I converted my 97 db to 2000. When checking to make sure all things looked ok, I came across 2 queries that won't run. They both use the DATE() function in the criteria, because I want records for the current date.
I get this error message:
Undefined function Date() in expression
I went to the help section and this is a valid function....should still work in 2000.
Is there something else I should have updated when I converted to 2000, or am I missing the obvious answer?
I appreciate all help!