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
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
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
Comments
Thanks for your answer. I expected something like this.
Do you happen to know if this is documented in the help center somewhere?
Regards
Markus
Its documented here:
https://jazz.net/library/article/1007 (search on "timestamps")