Criteria is Null Or is Not Null In Date Fields When Performing a Query (Doc ID 1606712.1)
Workaround for the issue in addition to:
1. Login to the application, performed a blank query on any date field say on Payments>All Payments
2. Click Query button and in the Start date field type
=Today() or Start Date with Null as =""
3. The application will return OK
In any field that is a non date field, enter [date field name] IS NULL
or
[date field name] IS NOT NULL
examples
[Commit Time] IS NULL
[Invoice Date] IS NOT NULL
Tagged:
0