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.