Hi,
I am setting due date based in SLA days and created date i.e. if i am creating a ticket the due date has to be set dynamically based on the SLA days and created date.
I am able to get the due date with the help of client script and script include. But it's counting the weekends as well. I need the due date to exclude weekends and take only the weekdays(5 working days (Monday to Friday)) into count.
REF:: Below the script
Script include:
var MyDateTimeAjax = Class.create();
MyDateTimeAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {
nowDateTime: function ()
{
var getDate = new GlideDateTime(gs.nowDateTime());
var cat = this.getParameter('sysparm_cat');
var subcat = this.getParameter('sysparm_subcat');
var itm = this.getParameter('sysparm_itm');
var gr = new GlideRecord("u_sla_admin_details");
gr.addQuery("u_category", cat);
gr.addQuery("u_sub_category", subcat);
gr.addQuery("u_item", itm);
gr.addQuery("u_record_type", "ADMIN");
gr.addQuery("u_active", "true");
gr.query();
if(gr.next())
{
var slaResult = (gr.u_ttr * 1 );
var slaCall = "";
if (gr.u_sla_days != "")
{
slaCall = (gr.u_sla_days * 1);
gs.log("slaCall value initially is: " + slaCall);
if(getDate.getDayOfWeekUTC() == 6)
{
gs.log("Ticket created in Saturday");
getDate.addDaysLocalTime(2);
}
else if(getDate.getDayOfWeekUTC() == 7)
{
gs.log("Ticket created in Sunday");
getDate.addDaysLocalTime(1);
}
getDate.addDaysUTC(slaCall);
if(getDate.getDayOfWeekUTC() == 6 )
{
gs.log("DayofWeek is Saturday");
getDate.addDaysLocalTime(2);
}
if(getDate.getDayOfWeekUTC() == 7)
{
gs.log("DayofWeek is Sunday");
if(slaCall >= 5)
{
gs.log("slaCall value is greater then 5: " + slaCall);
getDate.addDaysLocalTime(2);
}
else
{
gs.log("slaCall value is less then 5: " + slaCall);
getDate.addDaysLocalTime(1);
}
}
return getDate;
}
else
{
slaCall = "Not Applicable";
getDate = slaCall;
return getDate;
}
}
}
});
