End date Greater than Start date

Community Alums · ‎03-01-2023

Created two Date/time fields in format DD:MM:YYYY HH:mm:ss

End date(DD:MM:YYYY HH:mm:ss) can not be earlier than Start date(DD:MM:YYYY HH:mm:ss)??

Can anyone give script for this?

PavanK960672992 · ‎03-01-2023

Hi @Community Alums ,

If you have any issue on UI policy you can try Onchange client script on end date as below.

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '') {
        return;
    }
    var start = g_form.getValue('u_start_date'); //add start date field name
    if (newValue <= start) {
        g_form.addErrorMessage('End Date should be Greater than Start Date ');//add message here
        g_form.clearValue('u_end_date'); //add end date field name
    }
}

Screenshot:

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar

View solution in original post

Community Alums · ‎03-07-2023

Hi Pavan ,

I Will check This.

But I got the answer with bellow script.

EndDate Date Validation :

On Change Client Script :

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

if (isLoading || newValue == '') {

return;

}

var tFormat = g_user_date_time_format;

var EndDate = getDateFromFormat(g_form.getValue('EndDate_date'), tFormat);

if (EndDate < StartDate) {

g_form.addErrorMessage("EndDate date should not be before Start date");

g_form.setValue('EndDate_date', '');

}

Thank you.