Search question: after a specific date

RT Users
1

Dear RT,
I have a question regarding the searching for “after” a specific date on 2 consecutive months. The results for the current month include tickets from the previous. See below
When I do a search for
Status = 'resolved’
AND Owner = "user’
AND Resolved > '2016-12-31’
I get a specific total of 38
When I do a search for
Status = 'resolved’
AND Owner = "user’
AND Resolved > '201-01-31’
I get a specific total of 6
The 6 tickets showing for Feb are also in the report for Jan? Why?
I’m using RT v4.1.11

2

Dear RT,

I have a question regarding the searching for “after” a specific date on 2
consecutive months. The results for the current month include tickets from
the previous. See below

When I do a search for

Status = ‘resolved’

AND Owner = “user’

AND Resolved > ‘2016-12-31’

I get a specific total of 38

When I do a search for

Status = ‘resolved’

AND Owner = “user’

AND Resolved > ‘201-01-31’

Assuming this is 2017, not just 201

I get a specific total of 6

The 6 tickets showing for Feb are also in the report for Jan? Why?

Because you spcified > 2016-12-31, which encompasses everything up to
today. Essentially, your two searches are identical, but one starts earlier
than the other. You’d need to limit your date with something like
Resolved < 2017-02-01
to eliminate anything past Jan 31. At least that’s how I’m reading it;
sorry if I’m mistaken.

I’m using RT v4.1.11

Alex Hall
Automatic Distributors, IT department
ahall@autodist.com