Hi Community,
The use case is to restrict past dates in the 'Date' field. And it needs to be validated at the form level and also at the list view.
Note: Select the date field that the client script runs on.
OnChange:
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var cdt = newValue; //value for the Desired Due Date on the form
var dttype = 'day'; //this can be day, hour, minute, second.
var ajax = new GlideAjax('ClientDateTimeUtils'); //ajax call to compare selected date
ajax.addParam('sysparm_name', 'getNowDateTimeDiff'); //function call to do the calculation
ajax.addParam('sysparm_fdt', cdt); //pass the date
ajax.addParam('sysparm_difftype', dttype); //pass the format
ajax.getXML(doSomething); //callback function to present the results
function doSomething(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
//alert(answer);
if (answer < -1) {
g_form.clearValue('u_installation_date'); //clear the invalid value
alert('Please select today or a date in the future.'); //alert user to re-enter
}
}
}
OnCellEdit:
function onCellEdit(sysIDs, table, oldValues, newValue, callback) {
var saveAndClose = true;
//Type appropriate comment here, and begin script below
var cdt = newValue; //value for the Desired Due Date on the form
var dttype = 'day'; //this can be day, hour, minute, second.
var ajax = new GlideAjax('ClientDateTimeUtils'); //ajax call to compare selected date
ajax.addParam('sysparm_name', 'getNowDateTimeDiff'); //function call to do the calculation
ajax.addParam('sysparm_fdt', cdt); //pass the date
ajax.addParam('sysparm_difftype', dttype); //pass the format
ajax.getXML(doSomething); //callback function to present the results
function doSomething(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
if (answer < -1) {
alert('Please select today or a date in the future.'); //alert user to re-enter
saveAndClose = false;
}
callback(saveAndClose);
}
}
Script Include:
var ClientDateTimeUtils = Class.create();
ClientDateTimeUtils.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 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
var diff = gs.dateDiff(gs.nowDateTime(), firstDT, true);
var timediff = this._calcDateDiff(diffTYPE, diff);
//return "getNowDateTimeDiff: FIRST DT: " + firstDT + " -DIFFTYPE: " + diffTYPE + " -TIME DIFF: " + timediff;
return timediff;
}
});
