BAQ - Blank Date field records

[cchang]

I tried creating a BAQ against the InvcHead.DueDate = Blank but the criteria does not like the specified constant of “” or DueDate IsNull. How do you bring in only Blank date field records?

[gpayne (Greg Payne)]

There is a thread around about all of the ways that does not work, but I think there was one that did depending on the version.

[cchang]

I tried in 10.2.400 and it did not work. What was the one that did work?

[prash172 (Prashanth Malavalli Sathyanarayana)]

This should work I guess

[cchang]

Somehow when I tried the ISNULL on date fields, it is giving a syntax error.