Chg Date/Time to Format "Short Date"

[KTuohy]

I took over someones group of queries in a small personal database and simply brought them over into Access97 database that has lots of tables, reports etc.

He had his Date/Time converted to CVDate(format([Date Received],"Short Date")) which when brought into my db gives "Function isn't available in expressions in query expression 'CVDate(Format([Date Received],"Short Date")). Everyone gets the error message except for me!

This actually worked, at first, but now it doesn't work at all and I've changed the query to simply Format([Date Received],"Short Date") which has worked multiple times in other queries.

What's wrong? It gives the same error message without the CVDate. Why would it suddenly not recognize something so basic as changing the format of a date/time stamp to Short Date???

Before I'm forced to reinvent the wheel here with all new queries (that would represent about 23!) I'm begging for some clarity.

Thanks, Guys.

kathleen

 

[pbaldy]

Sounds like a reference problem:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[KTuohy]

Thank you, Paul. I never would have thought that the References would whack out something so basic.

I will certainly investigate further.

kathleen