Using Date in querys

[Guest]

I am receiving an error when I try to open a my database on a machine that
has access 2002. I am sure that I have used this on a machine that has both
2003 and 2002 so I don't think that that is the cause.

It gives me the error when I try to open a query that uses the Date
function. It says undefine function 'Date' in expression. The expression that
will not work is Date() but my hole expression is: age: DateDiff("yyyy",[Date
Of Birth],Date()).

This works on my other computer but just not this one. Any Suggestions?

 

[Van T. Dinh]

It sounds like you have Reference errors on this PC. Try:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html