restricting a date field

patricklatella · ‎06-07-2017

Hi helpful friends!

reposting this...I've gotten help already (thanks guys!) with several codes that I could not get to work properly and have gotten my head pretty spun around jumbling 3 different solutions, which again unfortunately I could not get to work. Looking to start fresh. Seeing lots of entries in the community on this but with the wide degree of differences in restrictions people are shooting for I'm having difficulty extrapolating.

I have a date field on a catalog item that I need to put restraints on.

I need it to only allow an entry of a date 6 or more BUSINESS days in the future.

the name of my date field is "needed_by"

Any help is most appreciated!

amlanpal · ‎06-07-2017

Hi Patrick,

You need to write the onChange Catalog Client Script on change of the variable named 'needed_by' and call a Script include where the validations are done. Please find the scripts for that here. Please refer my response on this thread: Issue related to Date/Time variable

Client Script:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

if (isLoading || newValue === '') {

return;

}

var cdt = newValue; //The date field

var dttype = 'day'; //this can be day, hour, minute, second. By default it will return seconds.

/******** This Checks whether the selected date is in the Past or Not************************/

var ajax = new GlideAjax('ClientDateTimeUtils_New');

ajax.addParam('sysparm_name','getNowDateTimeDiff');

ajax.addParam('sysparm_fdt', cdt);

ajax.addParam('sysparm_difftype', dttype);

ajax.getXML(doSomething);

function doSomething(response){

var answer = response.responseXML.documentElement.getAttribute("answer");

if(answer<0){

alert("Date & Time should not be Prior to Current Date & Time");

g_form.clearValue('date'); // Pass the variable name here

g_form.setMandatory('date', true);

}

/************* This Checks whether the selected date is within 6 business day ahead & Not weekend**********/

var ga = new GlideAjax('ClientDateTimeUtils_New');

ga.addParam ('sysparm_name','isBusinessDay');

ga.addParam ('sysparm_schedule_name','8-5 weekdays');

ga.addParam ('sysparm_dateTime',newValue);

ga.getXML(CheckScheduleAgainstDatesParse);

function CheckScheduleAgainstDatesParse (response) {

var answer = response.responseXML.documentElement.getAttribute("answer");

if(parseInt(answer)>63){ //For 6 days with 9 hour per day

alert("Date should be within 6 business days & within business working hours");

g_form.clearValue('date');

g_form.setMandatory('date', true);

}

Script Include:

var ClientDateTimeUtils_New = Class.create();

ClientDateTimeUtils_New.prototype = Object.extendsObject(AbstractAjaxProcessor, {

//Takes a Single Date/Time Field and returns its time difference from nowDateTime().

//params = sysparm_fdt (the first date/time field), sysparm_difftype (time based format to return result. See "_calcDateDiff" function comments)

getNowDateTimeDiff: function(){

var diff;

var firstDT = this.getParameter('sysparm_fdt'); //First Date-Time Field

var diffTYPE = this.getParameter('sysparm_difftype'); // Date-Time Type to return the answer as. Can be second, minute, hour, day

diff = gs.dateDiff(gs.nowDateTime(), firstDT, true);

var timediff = this._calcDateDiff(diffTYPE, diff);

return timediff;

},

//Private function to calculate the date difference return result in second, minute, hour, day.

_calcDateDiff: function(diffTYPE, seconds){

var thisdiff;

if (diffTYPE == "day"){thisdiff = seconds/86400;}

else if (diffTYPE == "hour"){thisdiff = seconds/3600;}

else if (diffTYPE == "minute"){thisdiff = seconds/60;}

else if (diffTYPE == "second"){thisdiff = seconds;}

else {thisdiff = seconds;}

return thisdiff;

},

//Takes a GlideDate field and schedule

//Returns true if the date falls within the given schedule and within today+6 Business days, false otherwise.

isBusinessDay: function (){

var sched;

var rslt;

var dur = 64;

var schedname = this.getParameter('sysparm_schedule_name');

var date_time = this.getParameter('sysparm_dateTime');

var schedRec = new GlideRecord('cmn_schedule');

schedRec.get('name', schedname);

//automatically use correct API for instance build

if (typeof GlideSchedule != 'undefined')

sched = new GlideSchedule(schedRec.sys_id);

else

sched = new Packages.com.glide.schedules.Schedule(schedRec.sys_id);

//Get the date/time in correct format

var DateTime = new GlideDateTime();

DateTime.setDisplayValue(date_time);

rslt = sched.isInSchedule(DateTime);

if (rslt){

var myUserTZ = gs.getUser().getTZ();

var dc = new DurationCalculator();

dc.setSchedule(schedRec.sys_id);

dc.setTimeZone(myUserTZ);

dur = dc.calcScheduleDuration(gs.now(), date_time)/3600;

}

return dur.toString();

}

});

I hope this helps.Please mark correct/helpful based on impact

View solution in original post

patricklatella · ‎06-07-2017

Hi Amlan,

thanks so much, I've been working with your code from your previous thread and have had trouble making the changes needed to make it work in my environment.

So you're saying the only changes I'll need to make are to replace my field name "needed_by" in the places where it says this?

// Pass the variable name here

correct?

amlanpal · ‎06-07-2017

Hi Patrick,

Yes, you need to change the variable name to 'needed_by'. In my script, I have used the variable name as 'date' which is getting used in clearing the value and making the variable mandatory.

I would request you to give it a try. Hope this works in your case.

I hope this helps.Please mark correct/helpful based on impact

Vinutha · ‎02-11-2024

Post is very useful please help for 7 business days, which line of code requires a change to achieve for 7 business days which also should check for schedule

patricklatella · ‎06-07-2017

thanks Amlan, and then one more thing...what do I do with this line?

gaBusinessDay.addParam('sysparm_sched', '8-5 weekdays excluding holidays'); //Pass the schedule name here

when you say "pass the schedule name here", not sure what I need to do...do I need to change this line?

amlanpal · ‎06-07-2017

Hi Patrick,

When you say that the date would be in Business day, that means the date will follow one particular schedules which has it's own entries (Workdays timing including any defined holidays). In the system OOB there is a schedule present, named '8-5 weekdays excluding holidays'. If you have any custom schedules which you are following in your organization, please provide the name of the schedules there. You can find the list of schedules by navigating System Scheduler-->Schedules.

I hope this helps.Please mark correct/helpful based on impact