Date()

[Jennifer Gose]

We were just upgraded to 2007 from 2003. I have a database that I use every
day that has different errors in it now that it has been converted to 2007.
One is 2007 doesn't seem to accept Date() anymore. I use this to query only
current dates. Is there something I can use to replace this? Why is it still
in Built-In Functionsis it doesn't work?

 

[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

Note: The info doesn't cover Access 2007, but I bet that it's a similar
problem.