- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2023 02:31 AM
Hello All,
Am running the BR to check if the PIN generation time passed the 24hrs. Here is the below script.
Thanks.
(function executeRule(current, previous /*, gs*/) {
var pingenerationtime = current.getValue('u_pin_generation'); // Get the PIN creation time
var currentTime = new GlideDateTime(); // Get the current time
var hoursElapsed = GlideDateTime.subtract(currentTime, pingenerationtime);
var diff = hoursElapsed.getNumericValue() / 3600;
// Check if 24 hours have passed
if (diff >= 24) {
current.pin_expired = true;// Mark the PIN as expired
current.update(); // Save the record
}
})(current, previous);
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2023 02:50 AM
use this
(function executeRule(current, previous /*, gs*/) {
var pingenerationtime = new GlideDateTime(current.getValue('u_pin_generation')); // Get the PIN creation time
var currentTime = new GlideDateTime(); // Get the current time
var dur = GlideDateTime.subtract(currentTime, pingenerationtime);
var diff = dur.getByFormat('HH');
// Check if 24 hours have passed
if (diff >= 24) {
current.pin_expired = true;// Mark the PIN as expired
current.update(); // Save the record
}
})(current, previous);
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
10-25-2023 02:50 AM
use this
(function executeRule(current, previous /*, gs*/) {
var pingenerationtime = new GlideDateTime(current.getValue('u_pin_generation')); // Get the PIN creation time
var currentTime = new GlideDateTime(); // Get the current time
var dur = GlideDateTime.subtract(currentTime, pingenerationtime);
var diff = dur.getByFormat('HH');
// Check if 24 hours have passed
if (diff >= 24) {
current.pin_expired = true;// Mark the PIN as expired
current.update(); // Save the record
}
})(current, previous);
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
10-25-2023 03:15 AM
Thanks Ankur,
Am checking the script, will let you know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2023 05:32 AM
Thanks @Ankur Bawiskar , its working i accepted the solution.
my only concern is what will be the when to run condition?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2023 06:32 AM
it should be before insert/update and remove current.update()
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader