Planned start/end date cannot be before the created date

[JordyZ]

Hi,

On the change form, I'd like an alert for when a date is selected for the planned start/end date that is before the created date of the change. I have an onChange client script but it's not giving me an alert.

This is my current onChange client script for planned start date (same one for planned end date):

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


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


        return;


    }


    //Type appropriate comment here, and begin script below


    var type = g_form.getValue('change_type'); 


    var plannedStart = g_form.getValue('start_date');

    var opened = g_form.getValue('sys_created_on');


    if (type == 'normal' || type == 'standard' || type == 'emergency') { 

        if (plannedStart < opened) {


            alert('Planned start date cannot be before opened date'); 


            return false;


        }


    }


}

 What's wrong with it? Thanks in advance!

[JordyZ]

Thanks @Upsilon , I think getDatefromFormat did the trick here!

[Servicenow34]

Have you checked if type values are satisfying the if condition ?

[Sandeep Rajput]

Use the following script and let me know if it works for you.

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === '') {

        return;

    }
    //Type appropriate comment here, and begin script below

    var type = g_form.getValue('type');

    var plannedStart = g_form.getValue('start_date');
    var opened = g_form.getValue('sys_created_on');

    if (type == 'normal' || type == 'standard' || type == 'emergency') {

        if (plannedStart < opened) {

            alert('Planned start date cannot be before opened date');
            return false;
        }
    }
}

Also make sure that you have the highlighted fields available on the form in order to make this script work.

In your script, you are fetching the value of change type from 

  var type = g_form.getValue('change_type'); 

Where as it should be

    var type = g_form.getValue('type');

[Ankur Bawiskar]

@JordyZ 

Is sys_created_on field on form? if not then your script won't work

If yes this will work

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
	if (isLoading || newValue === '') {
		return;
	}
	//Type appropriate comment here, and begin script below

	var type = g_form.getValue('type');

	var plannedStart = new Date(g_form.getValue('start_date')).getTime();
	var opened = new Date(g_form.getValue('end_date')).getTime();

	if (type == 'normal' || type == 'standard' || type == 'emergency') {
		if (plannedStart < opened) {
			alert('Planned start date cannot be before opened date');
			return false;
		}
	}
}

If it's not on form then use display BR on change_request table and pass the sys_created_on via g_scratchpad variable

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
	if (isLoading || newValue === '') {

		return;

	}
	//Type appropriate comment here, and begin script below

	var type = g_form.getValue('type');

	var plannedStart = new Date(g_form.getValue('start_date')).getTime();
	var opened = new Date(g_scratchpad.createdTime).getTime(); // pass the g_scratchpad from display BR

	if (type == 'normal' || type == 'standard' || type == 'emergency') {

		if (plannedStart < opened) {

			alert('Planned start date cannot be before opened date');
			return false;
		}
	}
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@JordyZ 

Thank you for marking my response as helpful.

As per new community feature you can mark multiple responses as correct.

If my response helped please mark it correct so that it benefits future readers.