Undefined function "Date" in expression

[aMack]

When running the a query with the following Criteria :

[Invoice Date]= Is Null Or >Date()-45

I get the following error message:

Undefined Function "date" in expression


This query has worked in the past - now it works on my Laptop but not on our
server??

 

[KARL DEWEY]

Try dropping the equal sign.

 

[Bob Barrows [MVP]]

When running the a query with the following Criteria :

[Invoice Date]= Is Null Or >Date()-45

I get the following error message:

Undefined Function "date" in expression


This query has worked in the past - now it works on my Laptop but not
on our server??

Very ancient problem - I used to see it in the newsgroups baick in 97-98.
Let's see if i can find the solution ...

Ah yes, the old "broken reference" problem ... here's a link:
http://www.pcreview.co.uk/forums/thread-1163628.php

 

[Jerry Whittle]

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