Aging Report (between 14 and 30 days old only)

Jon Collins1 · ‎07-20-2017

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 · ‎07-20-2017

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.

View solution in original post

Tony Cheung · ‎01-14-2020

I believe the above is standing on today and look back 14~30 days old ticket. How to make it to do this on a specific date instead of today?

Thx.

Uncle Rob · ‎01-15-2020

If you have a specific day and want to do X days before /after, just use the BETWEEN operator.