creating filter on tickets by age

[Robin Radanovics]

I am trying to create a filter on tickets created by a certain group that are not closed and want total tickets by age- <30 days, 30-60 days and >61 days. Is this query possible in version 4.1? any suggestions on the best way to accomplish this?

currently set up as:

project and issue type and reported by and status !=closed and createdDate = "<30d" AND "=30-60d" AND ">61d"

[Thomas Schlegel]

Hi

this should do it:

< 30 days: createdDate >= -30d

30 - 60 days: createdDate >= -60d AND createdDate <= -30d

< 60 days: createdDate <= -61d

Best regards

Thomas

[Steve Veach]

Tom this is very helpful. I find the syntax very confusing and counter-intuitive.

The last line you typed seems to have something wrong perhaps:

< 60 days: createdDate <= -61d

Did you mean this?

> 60 days: createdDate <= -61d