AnsweredAssumed Answered

Finds with date fields (?)

Question asked by JeffDening on Mar 7, 2011
Latest reply on Mar 7, 2011 by philmodjunk


Finds with date fields (?)


I have a work order tracking database set up and I am trying to see the work that is pending.  There is a field for "Date Completed" and I am having a hard time running a Find for that field.

Since it is a date field it wants any query to be in date format as well.  Is there a way for it to find a 0 value or empty?

I am temporarily getting around it with sorting but I don't need to see the ones that have a date completed.