Need to autopopulate the Resolve time field based on the resolved time and opened time.

Nageshwari P
Tera Contributor

Hi Everyone,

 

I have a requirement that when an incident ticket is resolved that resolution time need to be auto populated in seconds in resolve time field. It need to be calculated from Opened time to resolved time.

If possible: Additionally we need to add the conditions like excluding weekends and holidays.
Can you please help me to resolve this issue.

Thanks in advance.

Best Regards,
Nageshwari P.

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@Nageshwari P 

OOTB incident Resolved time is filled, check the code and enhance your logic for your table

This OOTB Business rule does it for incident "mark_resolved"

you can see this to calculate the difference between 2 dates using schedules and store in Duration field

give your schedule and enhance the logic to pick created and now time (resolve time)

calculate Duration and Business Duration in scoped application 

If my response helped please mark it correct and close the thread so that it benefits future readers.

 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Nageshwari P 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Nageshwari P
Tera Contributor

Apart from the condition on scheduled, In general format we need to calculate and auto populate, How can we acheive this?

 

@Nageshwari P 

I already shared details above.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader