MS Access Query Error: DataType Mismatch in Criteria Expression?

[mrmmickle1]

I am getting this error message when I try to run my update query: DataType Mismatch in Criteria Expression



I have a validated form that users input dates into. It should not be possible to enter an invalid date.


Here is my SQL Statement.

INSERT INTO [INPUT_GreenSheets_Plates_Archive]
SELECT * FROM [INPUT_GreenSheets_Plates]
WHERE 1 = 1
AND CDBL(DATESERIAL(YEAR([RecordTime]), MONTH([RecordTime]), DAY([RecordTime]))) >= 42005
AND CDBL(DATESERIAL(YEAR([RecordTime]), MONTH([RecordTime]), DAY([RecordTime]))) <= 42165
AND [Status] = "Completed"

Dates Are: 1/1/2015 & 6/10/2015

DataType is Date/Time i.e. 6/3/2015 8:52:39 AM
What does this error mean? Can someone please help me to resolve my issue?

[June7]

You are using wildcard to select all fields. Is this causing selection of an autonumber field? Does destination table have autonumber field?

I think the fields in both tables must be in the same order in table design.

Is there possibility RecordTime will be Null for any records?

[mrmmickle1]

June7,

Thanks so much. Somehow a blank or null value got into my date field. That was the issue! The query works perfectly now.