Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to get the time in along with the date in glide duration in the business rule.

Devi12
Giga Guru

‎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.

Devi12_0-1684474112503.png

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?

0 Helpfuls
  • 1,185 Views
11 REPLIES 11

Ankur Bawiskar
Tera Patron
Tera Patron
In response to Devi12

‎05-19-2023 03:43 AM

@Devi12 

whatever time you see for last opened data and you add days to it? what time you are expecting?

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

Devi12
Giga Guru
In response to Ankur Bawiskar

‎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.

0 Helpfuls