- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2020 02:47 PM
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?
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?
Solved! Go to Solution.
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2020 03:42 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2020 03:10 PM
You can change after to before to gain that.
However, what exactly are you trying to see from this report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2020 03:18 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2020 03:23 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2020 03:42 PM