date in a query

[Guest]

I am using Office XP or Office 2000 Premium.
On some of my compagnys computers, the expression for today, date(), is
accepted in a query, and on other computers I get a messsage: ther is a non
definied funktion "date" in the expression.
Does anyone know, what I can do?

 

[Guest]

Anytime I see a problem with the Date() function, I have a knee-jerk reaction
about references. Go to the following web page for information on checking
references:

http://www.mvps.org/access/bugs/bugs0001.htm