<div>
To add to what BrianWren has said, if all the references are there try a repair and compact on the database. &nbsp;I had this same problem with the Mid function and this seemed to solve it.
</div>


To add to what BrianWren has said, if all the references are there try a repair and compact on the database.  I had this same problem with the Mid function and this seemed to solve it.

<div>
Thanks both of you. &nbsp;I checked that all the references were there, and they were...except for utility.mda &nbsp;I found the file and saved. &nbsp;Still did not work. Then I ran compact and repair database. &nbsp;Still did not work. &nbsp;I went back in and checked off MS VB for Apps extensibilty 5.3<br />
<br />
Problem fixed.<br />
<br />
Thanks for the direction!<br />
<br />
Michelle
</div>


Thanks both of you.  I checked that all the references were there, and they were...except for utility.mda  I found the file and saved.  Still did not work. Then I ran compact and repair database.  Still did not work.  I went back in and checked off MS VB for Apps extensibilty 5.3

Problem fixed.

Thanks for the direction!

Michelle

<div>
Was at a total loss of where to go. &nbsp;He pointed me in the right direction and I got my fix!
</div>


Was at a total loss of where to go.  He pointed me in the right direction and I got my fix!

<div>
<div class="content wysiwyg-content">
I converted my 97 db to 2000. &nbsp;When checking to make sure all things looked ok, I came across 2 queries that won't run. &nbsp;They both use the DATE() function in the criteria, because I want records for the current date.<br />
<br />
I get this error message:<br />
Undefined function Date() in expression<br />
<br />
I went to the help section and this is a valid function....should still work in 2000. &nbsp;<br />
<br />
Is there something else I should have updated when I converted to 2000, or am I missing the obvious answer?<br />
<br />
I appreciate all help!
</div>
</div>


I converted my 97 db to 2000.  When checking to make sure all things looked ok, I came across 2 queries that won't run.  They both use the DATE() function in the criteria, because I want records for the current date.

I get this error message:
Undefined function Date() in expression

I went to the help section and this is a valid function....should still work in 2000.  

Is there something else I should have updated when I converted to 2000, or am I missing the obvious answer?

I appreciate all help!

Error (3085) with Date() function

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.