Inconsistent # of tickets on Created/Resolution Dates

[Eric Vormelker]

I'm getting inconsistent numbers in the number of tickets that are found when filtering all my projects by Created Date and, separately, Resolution Date.

I want to get a quarterly report. Our Agency has an atypical quarter -- starting in September.

When I try to filter by Dec 1 - Feb 29, I'm getting > 1000 tickets. But when I filter a month at a time I get the following:

For Created Date:

Dec: 271

Jan: 358

Feb: 348

Jan + Feb = 706

But if I filter Jan 1 - Feb 29, I get 748.

I get similar oddities for Resolution Date.

Is there a leap day issue here? Something else?

[Randy]

how are you filtering?  are you accounting for times also with startofday, startofmonth, startofyear functions?