Troubleshooting
Problem
You execute a query and receive unexpected query results for filter operations using the date/time filter keywords yesterday, today, and tomorrow.
Symptom
The filter operations affected by this issue are:
- Greater Than incorrectly includes values after 00:00:00 on the specified day of the keyword.
- Less Than Or Equal To incorrectly includes values after 00:00:00 on the specified day of the keyword.
- Equal To incorrectly excludes values after 00:00:00 on the specified day of the keyword.
- Not Equal To incorrectly includes values after 00:00:00 on the specified day of the keyword.
- Between incorrectly excludes values after 00:00:00 for the specified day of the keyword for its second parameter (the upper bound).
- Not Between incorrectly includes values after 00:00:00 for the specified day of the keyword for its second parameter (the upper bound).
Cause
The date/time filter keywords yesterday, today, and tomorrow incorrectly specify the start of the day (00:00:00) in all situations.
Resolving The Problem
To work around this issue, use the actual dates corresponding to yesterday, today, and tomorrow instead of the keywords in queries. It's also possible to use different operators in many cases. For example, "Is Greater Than Or Equal To [TODAY]" may be a reasonable alternative to "Equal To [TODAY]".
This issue does not effect the definition of a query.
The filter operations not affected by this issue:
- Greater Than Or Equal To
- Less Than
- Is Null
- Is Not Null
Note: This issue has been reported as APAR PK82174.
Was this topic helpful?
Document Information
Modified date:
01 August 2018
UID
swg21327844