Problem with Date() function

[Timberwolf]

I have a date field in my query and I'd like it to return records with today's date. I used "Date()" as the only criterion, but when I run the query, I get an error message: "Undefined function 'Date' in expression." Any suggestions? Thanks!

 

[Mike375]

I have a date field in my query and I'd like it to return records with today's date. I used "Date()" as the only criterion, but when I run the query, I get an error message: "Undefined function 'Date' in expression." Any suggestions? Thanks!

It should be just

Date()

 

[RichO]

I would think that if you were to use "Date()" (in quotations) the query would consider it to be a string and give you a data type mismatch error. Have you tried using the date function lately in any other applications?

You could be missing a reference in VBA. Just for kicks, design a new form and simply add an unbound text box with =Date() as the control source. If you get the same error, go into the VBA code window and check Tools >> References for a missing reference.

 

[Timberwolf]

Just to clarify, I didn't use the quotation marks in the criterion. I'll try the unbound text box suggestion. THANKS!

 

[Pat Hartman]

When standard functions such as Date() don't seem to work, you have a broken reference. Search here for missing references if you don't know what I'm talking about.

 

[Timberwolf]

Thanks much, Pat. That WAS the problem!!