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:
Hello @Sirri
Your screenshot shows date time format as:
My screenshot shows date time format as:
This means the code needs to be updated to handle 11/May/2026 type of date format. Please find below 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.";
// 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 parts = newValue.split(' ');
// Required to extract hour, minute, and second as separate values from the time string like "12:48:24"
var t = parts[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 (parts[0].indexOf('/') !== -1) { // check whether date contain a forward slash
// Display-style format: "11/May/2026"
var d = parts[0].split('/'); // Splits "11/May/2026" into pieces: ["11", "May", "2026"]
day = parseInt(d[0], 10); // First piece "11" which is day = 11
month = monthMap[d[1]]; // Second piece "May" → look up in monthMap → month = 4 (0-indexed)
year = parseInt(d[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 d = parts[0].split('-');
year = parseInt(d[0], 10);
month = parseInt(d[1], 10) - 1;
day = parseInt(d[2], 10);
}
// Required to construct a valid JavaScript Date; month is 0-indexed (0=Jan, 11=Dec)
var selected = new Date(year, month, day, parseInt(t[0], 10), parseInt(t[1], 10), parseInt(t[2], 10));
// Capture the current date/time as the baseline for both past-date and lead-time validations
var now = new Date();
// Communications cannot be scheduled in the past
if (selected.getTime() < now.getTime()) {
alert(pastMsg);
g_form.setValue('time_to_send_out_comms', ''); //Clear the variable value
return; // Stop processing further code
}
// 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 (selected.getTime() < minDate.getTime()) {
alert(leadMsg);
g_form.setValue('time_to_send_out_comms', ''); //Clear the variable value
return; // Stop processing further code
}
}
