How to get the time in along with the date in glide duration in the business rule.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2023 10:30 PM
Hi,
There is a business rule written on "sn_vul_vulnerable_item" table to calculate the business days. Below is the script for the same.
It is an onBefore business rule. Currently it is calculating the target date only based on the field "last_opened_dt_tm". My requirement is to calculate the time also along with the date. How can I do that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-19-2023 03:43 AM
whatever time you see for last opened data and you add days to it? what time you are expecting?
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-19-2023 03:48 AM
If the last opened date and time is "2023-05-19 17:05:00" then the target time should be "2023-05-29 16:04:59". It is calculating the date correctly but not calculating time.