Report: incidents closed in 24hr period (between yesterday 7am and today 7am)

bigurty
Kilo Contributor

Hi,

I am trying to create a report which displays all incidents closed in a 24 hour period between yesterday 7am and today 7am. 

How do I go about building this condition for the report? 

 

Thanks in advance. 

1 ACCEPTED SOLUTION

Adam Stout
ServiceNow Employee
ServiceNow Employee

I would recommend actual days as stated above (it is important to note that reports use the current user's timezone, with Performance Analytics, you can specify the time zone).

If you need to do it, I believe this will work:

find_real_file.png

View solution in original post

3 REPLIES 3

Jeff Currier
ServiceNow Employee
ServiceNow Employee

This is an old thread on this topic.

The easier ways is a report with close date yesterday, but that is 12:00-12:00.  Getting the specific time is harder. 

Adam Stout
ServiceNow Employee
ServiceNow Employee

I would recommend actual days as stated above (it is important to note that reports use the current user's timezone, with Performance Analytics, you can specify the time zone).

If you need to do it, I believe this will work:

find_real_file.png

bigurty
Kilo Contributor

That's great, thanks Adam & Jeff for your replies 🙂