BAQ not filtering on blank date

Epicor ERP 9
1

I wrote a BAQ where I want to know customer that Pay their invoices Today.

I linked the Invoice Head to the Cash Detail.

I have criteria where CashDtl.TranDate = now using current Date + Specified Interval.

it is returning records where the CashDtl.TranDate is blank.

Is there a better way to do this?

2

You may want to try having your date field criteria equal a constant variable and have that variable be a question mark (?) or have it not equal a question mark if you trying to filter out blank dates. I think the question mark is a place holder for blank date fields in 9.