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

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