Skip to content
TheChatArchiveThe Chat Archive
gpt-4o-2024-05-13· OpenAIAi2 WildChat-4.8M (AI2)

In servicenow, i wrote this client script and working, but the date format is now…

  1. User

    In servicenow, i wrote this client script and working, but the date format is now changed. Please modify according to date format. For example my new date format is like 20-Jun-2024

  2. Assistant

    To modify the date format in your ServiceNow client script to a specific format like 20-Jun-2024, you'll need to update the script to format the date accordingly. Here’s an example of how you might do it in a client script:

    function onChange(control, oldValue, newValue, isLoading) {
        if (isLoading || newValue == '') {
            return;
        }
    
        // Convert the GlideDateTime to the desired format
        var gdt = new GlideDateTime(newValue);
        var formattedDate = gdt.getDayOfMonth() + "-" + getMonthName(gdt.getMonth()) + "-" + gdt.getYear();
    
        g_form.setValue('your_date_field', formattedDate);
    }
    
    function getMonthName(monthIndex) {
        var monthNames = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];
        return monthNames[monthIndex - 1];
    }
    
    // Example: setting the format for a specific date field
    g_form.setValue('your_date_field', formatDateString('your_date_field'));
    
    function formatDateString(dateField) {
        var dateValue = g_form.getValue(dateField);
        if (!dateValue) return '';
    
        var gdt = new GlideDateTime(dateValue);
        return gdt.getDayOfMonth() + "-" + getMonthName(gdt.getMonth()) + "-" + gdt.getYear();
    }
    

    In this script:

    • onChange: This function handles the onchange event for the date field.
    • getMonthName: This function maps the month index (1-12) to the abbreviated month name (Jan, Feb, etc.).
    • The formattedDate variable constructs the date string in the desired format (e.g., 20-Jun-2024).

    You need to replace 'your_date_field' with the actual name of the date field you are targeting.

    Explanation:

    1. GlideDateTime: GlideDateTime is used to handle date and time in ServiceNow.
    2. Formatted Date String: We construct the date string in the format DD-MMM-YYYY by combining the day, short month name, and year.
    3. Month Conversion: The month is converted from number to abbreviated name using an array.

    Usage:

    • Attach this script to the appropriate client script for your form or field.
    • Make sure the date format expectations align with how your system stores and processes dates.

    This script should ensure that your date field is formatted as DD-MMM-YYYY such as 20-Jun-2024.