Report of Start date and Current date duration

[Neeta1]

Hi Experts ,

How to create a report in ServiceNow to calculate Duration of start time and current time ?

[shloke04]

Hi,

you can make use of Function in Report to calculate this . Please refer to screenshot below in a report what you need to do:

Under Configure Tab, you will find a button as "Configure Function Field". Once clicked Enter the Name of your Function , you can give any name there and then make use of different operation available as shown below:

In Screenshot above you can select Datediff from Add Operation box and select your fields seprated by comma.

This will give you the desired result as you want.

https://docs.servicenow.com/bundle/rome-now-intelligence/page/use/reporting/concept/function-fields-reporting.html

https://docs.servicenow.com/bundle/rome-now-intelligence/page/use/reporting/task/create-function-field.html

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[Neeta1]

Hi,

Thanks for your response .

Is there any way to get the date duration from the current date.

I am getting below error -

[Neeta1]

Can someone please assist here?

Is it feasible by using performance Analytics ?

[Ecol]

I have the same problem,
You managed to solve it ?