Need to autopopulate the Resolve time field based on the resolved time and opened time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 02:19 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 02:40 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2025 09:25 PM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 02:56 AM
Apart from the condition on scheduled, In general format we need to calculate and auto populate, How can we acheive this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 03:02 AM
I already shared details above.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader