null or empty date field

[cthompson]

What is the proper syntax in a query to identifying records with no entry in a date field? I keep getting a field type mismatch. I tried converting the date to a number rendering the same results.

 

[Joe4]

If it is truly a date field, use Is Null on the Criteria row for that field to return records with no date entry.

 

[cthompson]

Perfect thank you