Incidents created 3,4 or 5 days ago

troyjohnson · ‎04-02-2019

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 · ‎04-02-2019

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!

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

View solution in original post

Prateek kumar · ‎04-02-2019

so you are wanting the incidents created 5days ago??

or between 3days ago and 5days ago?

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

troyjohnson · ‎04-02-2019

3 separate reports. One for 3 days ago. One for 4 days ago. One for 5 days ago. "Between" doesn't work because of the limited options.

Prateek kumar · ‎04-02-2019

How about a filter like this

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

troyjohnson · ‎04-02-2019

That doesn't return any information. The "Relative" option will go back *exactly* 3 days ago, to the exact time you run the report.