Data Type Mismatch - no missing references

[Nolan Madson]

A query that's been working for months suddenly started giving me a
"data type mismatch" error. I found that it was CDate that was giving
me the problem. As per suggestions in this group, I checked the
References, but none were listed as "missing." Can anyone give me any
further pointers as to what Access has done to my query and how to fix
it?

TIA,
Nolan Madson

 

[Gary Walter]

A query that's been working for months suddenly started giving me a
"data type mismatch" error. I found that it was CDate that was giving
me the problem. As per suggestions in this group, I checked the
References, but none were listed as "missing." Can anyone give me any
further pointers as to what Access has done to my query and how to fix
it?

Hi Nolan,

One guess (not seeing your query):

Make a simple query using table
that contains date field.

Include appropriate fields in query
plus one calculated field

IsDate([yourdatefield])

set Criteria to

0

i.e., find records
for non-date (and Null date):

SELECT *
FROM yourtable
WHERE IsDate([yourdatefield])=0;

Or another reason CDate might not work...

did someone change Regional Settings?

CDate works if
-Windows Regional Setting are set to English(United States)
-Date is set to Month, Day, Year (Short Date Style = M/d/yyyy)

Simple ideas you may have already checked,
but always start with "simple" first.

Good luck,

Gary Walter