Incidents created 3,4 or 5 days ago

[troyjohnson]

We're trying to pull reports of all incidents opened 3 days, or 4 days, or 5 days ago and using relative doesn't provide us with any data.  Using "Between" doesn't provide us with the options we're looking for.

We're currently on the Kingston release.

Also...the new UI is terrible.  You can't specify any filters on it.  Is there something I'm missing on that?

Thank you!

[Allen Andreas · Accepted solution]

Unfortunately, date fields prohibit the use of javascript, which would allow you to tap into a script include...which you'd use to query for the gs.daysAgo(3); etc...so...here's a bit of a "wacky" way to get it to work...look at this thread:

https://community.servicenow.com/community?id=community_question&sys_id=640113e9dbdcdbc01dcaf3231f96...

Please mark reply as Helpful/Correct, if applicable. Thanks!

[noorulainatta21]

Hi,
To make at once a 3 to 5-day report, you can use this filter.

If you want to take one day's report try the following filter. 

I hope it will help. Thumbs up if it's helpful.

Thank You,