It's all about the answers!

Ask a question

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

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

Accepted answer

permanent link
Brian Fleming (1.6k11928) | answered Apr 11 '14, 11:45 a.m.
A similar question was asked here:

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

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?


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

Its documented here: (search on "timestamps")

Your answer

Register or to post your answer.