Catalog variable Date/Time validation – 2 working days (Sun–Thu) with hour‑based lead time

[Sirri]

Hi Community,

I’m working on a Service Catalog Date/Time variable validation and would like confirmation or suggestions for improvement.

Variable Details

• Variable name: time_to_send_out_comms
• Variable type: Date/Time
• Used on: Service Request (SR)
  
  Business Requirement

  1. Past Date/Time Validation

  • The selected date/time must not be in the past

  ✅ If user selects a past date/time, show the error message:

  “The time chosen to send out the communication occurs in the past, kindly select a future date/time to proceed.”
  
  

  2. Minimum Lead Time – 2 Working Days (Hour‑Based)

  • The selected date/time must be at least 2 working days after the current date/time
  • Working days: Sunday to Thursday
    (Friday and Saturday are non‑working days)
  • Lead time must be hour‑based, not just date‑based

  Example

  Current date/time:

  13/May/2026 13:05:00 (Wednesday)
  

  ✅ Valid selections

  • 17/May/2026 13:06:00
  • 17/May/2026 15:00:00
  • Any date/time after the same HH:mm:ss on the 2nd working day

  ❌ Invalid selections

  • 17/May/2026 13:04:00
  • Any date/time before 17/May/2026 13:05:00

  ✅ If user does not allow 2 working days lead time, show the error message:

  “Please allow two working days lead time for approvals and content review.”
  Please provide with exact code so it will helpful to me.

  Thank you

  
  
  
  
  

[Sirri]

@Vishal Jaswal ,

Thank you. It seems to be working partially; however, I noticed that for 22nd and 23rd May (Friday and Saturday), no alerts are being displayed. This indicates that the solution is not working completely.

Could you please check this behavior for future Friday and Saturday dates? That should help in identifying the issue more clearly.

As per the requirement, these dates should also be restricted, so we expect alerts to be triggered for them as well.

Thank you

[Vishal Jaswal · 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:

[Sirri]

@Vishal Jaswal ,

Thank you so much for providing the entire solution.

[Tejas Adhalrao]

Hi @Sirri  ,

You can achieve this requirement using an onChange Catalog Client Script on the Date/Time variable time_to_send_out_comms.

this script handles :

• Past date/time validation
• 2 working days lead time validation
• Sunday–Thursday working week
• Hour/minute/second level validation

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

    if (isLoading || !newValue) {
        return;
    }

    g_form.hideFieldMsg('time_to_send_out_comms', true);

    // Selected date/time
    var selectedDateTime = new GlideDateTime(newValue);

    // Current date/time
    var currentDateTime = new GlideDateTime();

    // ----------------------------------------------------------------
    // 1. Past Date/Time Validation
    // ----------------------------------------------------------------

    if (selectedDateTime.before(currentDateTime)) {

        g_form.showFieldMsg(
            'time_to_send_out_comms',
            'The time chosen to send out the communication occurs in the past, kindly select a future date/time to proceed.',
            'error'
        );

        g_form.clearValue('time_to_send_out_comms');
        return;
    }

    // ----------------------------------------------------------------
    // 2. Minimum 2 Working Days Lead Time Validation
    // Working Days = Sunday to Thursday
    // Friday & Saturday are non-working days
    // ----------------------------------------------------------------

    var minimumAllowedDateTime = new GlideDateTime(currentDateTime);

    var workingDaysCount = 0;

    while (workingDaysCount < 2) {

        // Add one calendar day
        minimumAllowedDateTime.addDaysLocalTime(1);

        // Day of week
        // 1 = Monday
        // 2 = Tuesday
        // 3 = Wednesday
        // 4 = Thursday
        // 5 = Friday
        // 6 = Saturday
        // 7 = Sunday

        var dayOfWeek = parseInt(
            minimumAllowedDateTime.getDayOfWeekLocalTime(),
            10
        );

        // Valid working days: Sunday to Thursday
        if ((dayOfWeek >= 1 && dayOfWeek <= 4) || dayOfWeek == 7) {
            workingDaysCount++;
        }
    }

    // Final validation
    if (selectedDateTime.before(minimumAllowedDateTime)) {

        g_form.showFieldMsg(
            'time_to_send_out_comms',
            'Please allow two working days lead time for approvals and content review.',
            'error'
        );

        g_form.clearValue('time_to_send_out_comms');
    }
}

[Sirri]

@Tejas Adhalrao ,

Thank you for your response.

Could you please confirm if you have tested this at your end and whether it is working as expected? I have tried implementing the code you provided, but it is not working in my case.

I am encountering an error, and I have attached a screenshot that includes both the issue and the console error for your reference. Kindly review the attachment and advise.

Script:

g_form.hideFieldMsg('time_to_send_out_comms');

// Selected date/time
var selectedDateTime = new GlideDateTime();
selectedDateTime.setDisplayValue(newValue);

// Current date/time
var currentDateTime = new GlideDateTime();

// ------------------------------
// 1. Past Date Validation
// ------------------------------
if (selectedDateTime.before(currentDateTime)) {

g_form.showFieldMsg(
'time_to_send_out_comms',
'The selected time is in the past. Please choose a future date/time.',
'error'
);

g_form.clearValue('time_to_send_out_comms');
return;
}

// ------------------------------
// 2. 2 Working Days Validation
// ------------------------------
var minimumAllowedDateTime = new GlideDateTime(currentDateTime);
var workingDaysCount = 0;

while (workingDaysCount < 2) {

minimumAllowedDateTime.addDaysLocalTime(1);

var dayOfWeek = minimumAllowedDateTime.getDayOfWeekLocalTime();

// Sunday–Thursday
if (dayOfWeek >= 1 && dayOfWeek <= 5) {
workingDaysCount++;
}
}

// Final validation
if (selectedDateTime.before(minimumAllowedDateTime)) {

g_form.showFieldMsg(
'time_to_send_out_comms',
'Please allow a minimum of 2 working days.',
'error'
);

g_form.clearValue('time_to_send_out_comms');
}