I have created a whole bunch of saved filters that work like a charm.
I need one more, super easy, but can't get it right.
First colum is "Lot #" and the criteria is "contains Spec" - checked.
Second criteria on colum "Date Closed" "Is blank". Simple, isn't it?
Well, when I apply the filter - all the rows where there is a date in the "Date Closed" column are displayed.
If I do the reverse: Date is not blank, then it works perfectly.
What am I doing wrong? (I verified that the "Date Closed" column is formated for dates).
Thank you in advance for your help.
