logo

NJP

Fix script to calculate difference between planned start date and current date of a change request

Import · Dec 21, 2020 · article

fix script to do lead time calculation, This can be used in a script include and called via client script by passing right variable values.

This script compares date diff between planned start date, current date using a schedule of your choice.

var sLog = '';

var isValid = false;

var plannedStartDate = new GlideDateTime();

plannedStartDate = getStartDate();

var dc = new DurationCalculator();

dc.setSchedule('7808de182f91e850f101ad2ef699b659' ); // schedule of CAB

var gdt = new GlideDateTime();

if(dc.calcScheduleDuration(gdt,plannedStartDate) >0) {

isValid = true;

}

sLog = "start Date =" + plannedStartDate;

sLog+= " Current Date= " + gdt;

sLog += " Is Date Valid =" + isValid;

gs.print(sLog);

function getStartDate() {

var grChg = new GlideRecord('change_request');

grChg.get('7557790f378c1300023d57d543990ed5');

return grChg.start_date;

}

Youtube link with explanation of script

ServiceNow change management - CalculateChangeLeadTime - YouTube

Updateset is available here https://developer.servicenow.com/connect.do#!/share/contents/3287388\_fix\_script\_to\_calculate\_difference\_between\_planned\_start\_date\_and\_current\_date\_of\_a\_change\_request?t=PRODUCT\_DETAILS

View original source

https://www.servicenow.com/community/itsm-articles/fix-script-to-calculate-difference-between-planned-start-date/ta-p/2315399