1 ACCEPTED SOLUTION
Hello @Sirri
Here is the updated onChange Client script:
function onChange(control, oldValue, newValue, isLoading) {
//Stop processing further code from running when the form initially loads with pre-existing values
if (isLoading) {
return;
}
// Stop processing further code from running when user clears the field, as there is nothing to validate
if (!newValue || newValue == '') {
return;
}
var pastMsg = "The time chosen to send out the communication occurs in the past, kindly select a future date/time to proceed.";
var leadMsg = "Please allow two working days lead time for approvals and content review.";
var weekendMsg = "Communications cannot be scheduled on a Friday or Saturday as these are non-working days. Please select a working day (Sunday–Thursday).";
// Month abbreviation to 0-indexed number mapping for display-style format (e.g., "11/May/2026 10:41:26")
var monthMap = {
'Jan': 0, 'Feb': 1, 'Mar': 2, 'Apr': 3,
'May': 4, 'Jun': 5, 'Jul': 6, 'Aug': 7,
'Sep': 8, 'Oct': 9, 'Nov': 10, 'Dec': 11
};
// Required to separate the date component from the time component for independent parsing
var dateParts = newValue.split(' ');
// Required to extract hour, minute, and second as separate values from the time string like "12:48:24"
var timeParts = dateParts[1].split(':');
var year, month, day;
//Please go through below links to understand below code:
/*
indexOf(): https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/indexOf
split(): https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/split
parseInt(): https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/parseInt
Date(): https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/Date
*/
// For Date Time format: "11/May/2026 10:41:26"
if (dateParts[0].indexOf('/') !== -1) { // check whether date contain a forward slash
// Display-style format: "11/May/2026"
var dateComponents = dateParts[0].split('/'); // Splits "11/May/2026" into pieces: ["11", "May", "2026"]
day = parseInt(dateComponents[0], 10); // First piece "11" which is day = 11
month = monthMap[dateComponents[1]]; // Second piece "May" → look up in monthMap → month = 4 (0-indexed)
year = parseInt(dateComponents[2], 10); // Third piece "2026" → year = 2026
} else {
//For Date Time format: "2026-05-20" -- You can comment this if you don't need it.
var dateComponents = dateParts[0].split('-');
year = parseInt(dateComponents[0], 10);
month = parseInt(dateComponents[1], 10) - 1;
day = parseInt(dateComponents[2], 10);
}
// Required to construct a valid JavaScript Date; month is 0-indexed (0=Jan, 11=Dec)
var selectedDate = new Date(year, month, day, parseInt(timeParts[0], 10), parseInt(timeParts[1], 10), parseInt(timeParts[2], 10));
// Capture the current date/time as the baseline for both past-date and lead-time validations
var now = new Date();
// VALIDATION #1: Communications cannot be scheduled in the past
if (selectedDate.getTime() < now.getTime()) {
alert(pastMsg);
g_form.setValue('time_to_send_out_comms', ''); //Clear the variable value
return; // Stop processing further code
}
// VALIDATION #2: Communications cannot be scheduled on non-working days (Friday or Saturday)
// getDay() returns 0=Sunday, 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday
var selectedDayOfWeek = selectedDate.getDay();
if (selectedDayOfWeek === 5 || selectedDayOfWeek === 6) {
alert(weekendMsg);
g_form.setValue('time_to_send_out_comms', ''); //Clear the variable value
return; // Stop processing further code
}
// VALIDATION #3: Calculate the earliest allowed date/time by starting from the current moment and adding 2 working days while preserving the exact time (hour-based comparison)
var minDate = new Date(now.getTime());
// Track how many valid working days have been counted toward the 2-day minimum
var workingDaysAdded = 0;
// Iterate day-by-day until exactly 2 working days (Sunday–Thursday) have been accumulated
while (workingDaysAdded < 2) {
// Advance the date by one calendar day for each iteration
minDate.setDate(minDate.getDate() + 1);
// Determine if the current day in the loop is a working day or a non-working day
var dayOfWeek = minDate.getDay();
// Skip Friday (5) and Saturday (6) as they are defined as non-working days per business requirements
if (dayOfWeek !== 5 && dayOfWeek !== 6) {
// Count only valid working days toward the 2-day lead time requirement
workingDaysAdded++;
}
}
// Selected date/time must be at or after the same hour/minute/second on the 2nd working day from now
if (selectedDate.getTime() < minDate.getTime()) {
alert(leadMsg);
g_form.setValue('time_to_send_out_comms', ''); //Clear the variable value
return; // Stop processing further code
}
}
Validation Results:
@Vishal Jaswal ,
Thank you for your response. I have given same code which you have given :
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
//Type appropriate comment here, and begin script below
var pastMsg = "The time chosen to send out the communication occurs in the past, kindly select a future date/time to proceed.";
var leadMsg = "Please allow two working days lead time for approvals and content review.";
var parts = newValue.split(' ');
var d = parts[0].split('-');
var t = parts[1].split(':');
var selected = new Date(
parseInt(d[0], 10),
parseInt(d[1], 10) - 1,
parseInt(d[2], 10),
parseInt(t[0], 10),
parseInt(t[1], 10),
parseInt(t[2], 10)
);
var now = new Date();
// Past date validation
if (selected.getTime() < now.getTime()) {
alert(pastMsg);
g_form.setValue('time_to_send_out_comms', '');
return;
}
// Lead time calculation (2 working days, excluding Fri & Sat)
var minDate = new Date(now.getTime());
var workingDaysAdded = 0;
while (workingDaysAdded < 2) {
minDate.setDate(minDate.getDate() + 1);
var dayOfWeek = minDate.getDay();
if (dayOfWeek !== 5 && dayOfWeek !== 6) {
workingDaysAdded++;
}
}
// Lead time validation
if (selected.getTime() < minDate.getTime()) {
alert(leadMsg);
g_form.setValue('time_to_send_out_comms', '');
}
}
Please check If I'm missing anything in onchange client script i have selected variable as
time_to_send_out_comms but still it's not working for me for reference please check below snips.
Nothing is coming when I selected past date or withing 2 working days. I'm not sure is this active are not Please can you provide the xml of that script and provide the name of that script so after importing i can verify. If I'm missing anything.
I have reviewed the approach you provided; however, it is still not working as expected. After applying my customizations, I am still facing issues. whatever i select the date every time it is showcasing the alert this not expected. Could you please review and help identify what might be missing?
For your reference, I am sharing the updated implementation below:
OnChange Client Script:
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var ga = new GlideAjax('CommsDateValidator');
ga.addParam('sysparm_name', "getInfo");
ga.addParam('sysparm_date', g_form.getValue('time_to_send_out_comms'));
ga.getXMLAnswer(function(answer) {
if (answer == 'true') {
alert('Please select a date after 2 business days');
g_form.clearValue('time_to_send_out_comms');
}
});
}
Script Include
Name: CommsDateValidator
Script:
Script:
var CommsDateValidator = Class.create();
CommsDateValidator.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getInfo: function() {
var dateSelected = this.getParameter('sysparm_date');
var nowDateTime = new GlideDateTime();
var days = 2;
var dur = new GlideDuration(days * 43200 * 1000);
// Schedule: 8x8 weekday schedule (Sun–Thu, excluding holidays)
var schedule = new GlideSchedule('18391defdb044210707e0474f39619fa');
var finalTime = schedule.add(nowDateTime, dur, '');
var updatedGdt = new GlideDateTime(dateSelected);
var finalTimeGdt = new GlideDateTime(finalTime);
if (updatedGdt < finalTimeGdt) {
return 'true';
}
return 'false';
},
type: 'CommsDateValidator'
});
I have also attached the schedule configuration snippets for your review. Kindly let me know if I have missed anything or if further adjustments are required.
I have added the sys id of the schedule (RX IT Working Hours) not schedule entry (Sunday-Thursday 7:30-6:30) I hope that is correct right?
I have added the sys id of the schedule (RX IT Working Hours) not schedule entry (Sunday-Thursday 7:30-6:30) I hope that is correct right?
Thank you
