Pulling dates

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

Guest

Hi,

I have a field name, in a table, with the data type as Date/Time.

I'm trying to create a query where if the field is empty, then return those
records of rows. I've already created a query if there is a date present,
"<>0", and that works fine. But when I create a query where the date, "=0",
then I get nothing. The input mask is 99/99/0000;0;_ if that means anything.

Can anyone help?

Thanks
 

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

Input Mask 1
Date Mask auto changes 1916 to 2016 2
How to validate a date entered on a form 2
Data Entry Form 3
Date 4
Input Mask 2
Date Input Mask and Value 2
Date format with input masks 2

Back
Top