How do I create a report that shows all records that are 7 days old?

Dukeh1
Kilo Guru

This seems so basic, but I realized that doing a filter like the example below gives me the last 7 days from the moment the report is ran, not the 7 days after creation date? 

find_real_file.png

I feel I must be making the simplest of oversights as I have almost no SN reporting experience. 

Does anyone know how to create a filter to show only records that have passed 7 days time from their respective create date?

1 ACCEPTED SOLUTION

Maybe you could do Created relative on 7 Days ago?

find_real_file.png

View solution in original post

4 REPLIES 4

Thomas_Davis
Administrator
Administrator

You can change after to before to gain that.

However, what exactly are you trying to see from this report?

Thanks for the reply.

I have a use case where we do not have actual SLA's for a sc_task, but am being asked to report on records of a particular item and active state that have aged more than 7 days from the records creation date.

 

So I need to see all active tasks for this item that are older than 7 days. 

 

Below is what I have, but when I changed to before, it is returning anything that seems to be older than 7 days from today; which is not what I need.

find_real_file.png

I might be thinking about part of this wrong. I am going to look closer at before. I believe for some reason I was thinking in my head to not see things with created dates greater than 7 days and I have no idea why. 

Maybe you could do Created relative on 7 Days ago?

find_real_file.png