Date() in query has suddenly stopped working

[phy310]

have multiple queries using Date() suddenly stopped working -getting
"undefined function 'Date' in expression"
Have tried Compact & Repair, and also Repairing Office
Any Suggestions?

 

[Clifford Bass]

Hi,

Try a decompile/recompile. See
<http://www.granite.ab.ca/access/decompile.htm> for details. If that does
not work, try importing everything into a new database.

Clifford Bass

 

[Jerry Whittle]

Panic not! It's just a simple references problem. Check out the following
web page:

http://tinyurl.com/AccessReferences