Hi SNC,
I need some assistance please regarding the below script. It's for a five days validation , it works for five days but does not take into account weekends or bank holidays.
Here's the script below and the script include . Please note,not great with scripting, I had help with this script. Appreciate your assistance.
Client Script
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
//Type appropriate comment here, and begin script below
var mydate = newValue;
var dtvalid;
var ga = new GlideAjax('daysdiff');
ga.addParam('sysparm_name','date_selection');
ga.addParam('sysparm_sdt',mydate);
ga.getXML(UserDateParse);
function UserDateParse(response)
{
dtvalid = response.responseXML.documentElement.getAttribute("answer");
if (dtvalid < 5) {
g_form.setValue('date',' ');
alert("The date should be atleast 5 days from today ");
}
}
Script Include
var daysdiff= Class.create();
var rec2 = new ArrayUtil();
daysdiff.prototype = Object.extendsObject(AbstractAjaxProcessor, {
date_selection: function() {
var sec1 = this.getParameter('sysparm_sdt');
var gdt = new GlideDateTime();
gdt.addSeconds(gdt.getTZOffset() / 1000);
var sec2 = gdt.getDate();
return DateSelect(sec2, sec1);
}
});
function DateSelect(rec3, rec4)
{
var dif = gs.dateDiff(rec3, rec4, true);
var time = (parseFloat(dif)*1000)/86400000;
gs.log('Today Date>>>>' + rec3);
gs.log('Planned Date>>>>' + rec4);
gs.log('Time Difference>>>' + time);
return time;
}
