IBM Support

Unexpected query results when using date/time filters that use yesterday, today, and tomorrow keywords

Technote (troubleshooting)


Problem(Abstract)

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.

Document information

More support for: Rational ClearQuest
Query

Software version: 7.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: All Editions

Reference #: 1327844

Modified date: 19 December 2008