Solved! Go to Solution.
Are the values in your attribute table <NULL> or are they simply blank, there is a difference.
I just tested an example in one of my maps and this is how I wrote the query, with CLOSEDATE as the [FIELDNAME].
NOT CLOSEDATE is NULL
This worked for me. Let me know if this format works for you.
Haskett