Data Type Mismatch - no missing references

  • Thread starter Thread starter Nolan Madson
  • Start date Start date
N

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
 
Nolan Madson said:
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?
Click to expand...
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
 
Back
Top