Query for Date = Blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Did you try ... WHERE SomeTable.SomeDate Is Null ... in your query?

V.
 
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.
 
Thanks,
That worked. I had tried putting Null in the field , but not IS NULL.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query Questions 7
How to SELECT with date criteria by SQL? 1
Date search query 0
#error - Blank 3
Date Field conundrum 3
Finding null-blank dates 2
data type mismatch when using dates 6
query for date 3

Back
Top