It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788
×11,929

question asked: Apr 11 '14, 4:59 a.m.
question was seen: 3,048 times
last updated: Apr 15 '14, 1:10 a.m.

Related questions

FAQ - How this Forum works

Why do I get different query results for "Creation Date before (including)" 2 years ago vs. 24 months ago vs. 4/11/2012?

0
Markus Nosse (151●1●28●28) | asked Apr 11 '14, 4:59 a.m.
edited Apr 11 '14, 5:55 a.m.
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

0
permanent link
Brian Fleming (1.6k●1●19●28) | answered Apr 11 '14, 11:45 a.m.
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
Markus Nosse commented Apr 14 '14, 4:01 a.m. | edited Apr 15 '14, 1:10 a.m.

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

Brian Fleming commented Apr 14 '14, 9:22 a.m.

Its documented here:
https://jazz.net/library/article/1007 (search on "timestamps")

Your answer

Register or to post 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.