How to show duration (after datediff) in reports

TT3
Kilo Guru

‎06-10-2022 03:32 PM

See my report setup below. I added a calculated field "Outage Duration" which uses datediff function provided by ServiceNow report to find difference between outage start and resolved date.

However, as you can see it shows duration field value as "12/31/1969" - the expectation is to show in minutes like 20 minutes or so. Is it possible in ServiceNow reports?

Further, I still have to substract on-hold time (I am capturing hold duration in a separate field, but I still need to use it in this calculation e.g. ourage start minus resolved minus hold duration. Is it possible in ServiceNow reports?

Report setup:

find_real_file.png

Preview file
98 KB
0 Helpfuls
  • 570 Views
1 REPLY 1

TT3
Kilo Guru

‎06-10-2022 03:47 PM

For the first issue, I have to change the return type as Duration. The next question is still there:

Further, I still have to substract on-hold time (I am capturing hold duration in a separate field, but I still need to use it in this calculation e.g. ourage start minus resolved minus hold duration. Is it possible in ServiceNow reports?

0 Helpfuls