Why do I get different query results for "Creation Date before (including)" 2 years ago vs. 24 months ago vs. 4/11/2012?
![]()
Hi,
today, I noticed strange behavior in RTC v4.0.2. I have a query using the creation date as argument: "Creation date before (including)" The result of the query varies depending on the argument given: * Creation date before (including) 2 years ago -> 2392 * Creation date before (including) 24 month ago -> 1900 * Creation date before (including) 4/11/2012 -> 1878 Of course, no other argument in the query has changed. I would have expected, that the number of items in the result are pretty much the same (at least when running the query on 4/11/14). However, the result varies by more than 20%. Anyone has an idea why this happens and maybe can provide an explanation ? Thanks in advance Markus |
Accepted answer
![]()
A similar question was asked here:
https://jazz.net/forum/questions/118019/relative-date-query-not-working-properly Based on that response your "Creation date before (including) 2 years ago" is actually querying since Jan 1, 2012 and "Creation date before (including) 24 month ago" is actually querying since April 1, 2012 Markus Nosse selected this answer as the correct answer
Comments Thanks for your answer. I expected something like this.
Its documented here:
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.