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).
[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Query","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1","Edition":"All Editions","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 August 2018
UID
swg21327844