Query for Date = Blank

[lovespar]

I need to be able to query on a database for blanks in the date field. So far
everything I have tried is reduced to a data mismatch error. Does anyone
have a solution to this?
Thanks in advance

 

[Vladimír Cvajniga]

Did you try ... WHERE SomeTable.SomeDate Is Null ... in your query?

V.

 

[Jerry Whittle]

If it's truly a Date field (not just a text field with something that looks
like a date in it) put Is Null in the criteria under the field.

 

[lovespar]

Thanks,
That worked. I had tried putting Null in the field , but not IS NULL.