Aging Report (between 14 and 30 days old only)

[Jon Collins1]

Hi Everyone,

I am trying to create an aging report for incidents at least 14 days old, but less than 30 days old. For some reason, I am not able to come up with the right fields to produce this.

Here is what I have so far:

I've tried to add a closing state that cuts it off at 30 days, but have not been able to find the right statement.

*I have a separate 30+ day aging report that goes out to this team; this report is for their management and should only catch 14-30 day old tickets that are still not closed/resolved.

Please advise.

Jon Collins

[Uncle Rob · Accepted solution]

First suggest you remove all other conditions to ensure they aren't interfering.   Also, I use Created, since Opened can by modified.

I *THINK* you want On Or Before 14 days ago.   You only want tickets to show if they are *at least* 14 days old.   Anything created on or after 14 days ago is actually closer to today, therefore *less* than 14 days old.

You then need a second condition that states On Or After 30 days ago, to make sure you don't show anything breaching 30 days old.

Be sure to remember you'll have a body of tickets missing.   Those that aren't at least 14 days old, and those older than 30 days.

[Jon Collins1]

That did it, thanks Robert!

[Raghavendra97]

What I see is that now we do not have option of on or before in relative and also we cannot select specific days with at or before as well so any work around

[Uncle Rob]

Relative operator has never had specific days selectable, because then its not relative, its specific.
If you wanted a specific date as a goal post you'd use the before/at-or-before/after/at-or-after

Relative is ONLY used to check before/after on a specific field who's value you don't always know.