date() issue - 'unrecognised function "Date" ' error

[Andie]

Hi,
I have just updated from 97 to 2002 and have found the
queries I created in 97 using the Date() (for current
date) no longer run, I'm getting an 'unrecognised
function "Date" ' error, does any one know what this is or
how to fix it?

 

[Van T. Dinh]

It is likely to be a Reference Error. See Douglas J.
Steele's article:

<http://members.rogers.com/douglas.j.steele/AccessReference
Errors.html>

HTH
Van T. Dinh
MVP (Access)