End date should not be more than 6 months from start date

Lakshman12 · ‎07-21-2020

I am working on functionality as below

I have two fields on catalog item includes – start date and end date. We do not want users to select end date not more than 6 months from start date.

For example: start date = 07/22/2020

If End date = 1/22/2021 (technically difference is more than 180 days because of few months has 31 days ).

Let us say if end user selects 1/23/2021 as end date, then I should alert them saying not to select as it is more than 6 months calendar days.

I would really appreciate your help. @Pradeep Sharma @Ankur Bawiskar @Chuck Tomasi

Thanks

Lakshman

Ankur Bawiskar · ‎07-22-2020

@Lakshman

Below worked for me:

1) If start date is 22nd July then adding 6months to that is 22nd Jan

2) Now it depends on how 6 months you consider since some months are having 30 and 31 days.

3) I would request to check with business for exact days and that would be better.

a) So if user gives 23rd Jan then it gives alert and clears as it is not valid

b) If user gives 22nd Jan then it is ok

Client Script:

Note: Ensure you give valid variable names for start and end dates

function onChange(control, oldValue, newValue, isLoading) {
	if (isLoading || newValue == '') {
		return;
	}

	var ga = new GlideAjax('DateTimeAjax');
	ga.addParam('sysparm_name', "compareDates");
	ga.addParam('sysparm_start', g_form.getValue('start_date')); // start variable
	ga.addParam('sysparm_end', g_form.getValue('end_date')); // end variable
	ga.getXMLAnswer(function(answer){
		if(answer != ''){
                        alert('End date should be within 6 months from start date');
			g_form.clearValue('end');	
		}
	});
	//Type appropriate comment here, and begin script below

}

Script Include: It should be client callable

var DateTimeAjax = Class.create();
DateTimeAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {

	compareDates: function(){

		var start = new GlideDateTime(this.getParameter('sysparm_start'));
		var end = new GlideDateTime(this.getParameter('sysparm_end'));
		start.addMonthsUTC(6);

		if(end.getNumericValue() > start.getNumericValue()){
			return 'End Date should be withing 6 months from start';
		}
		return '';
	},

	type: 'DateTimeAjax'
});

Output:

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Dharani2 · ‎03-31-2021

@Ankur Bawiskar

By using, var start = new GlideDate(this.getParameter('sysparm_start')); it is returning date with time, but I don't want time and want only date.

How can I achieve this?

Ankur Bawiskar · ‎04-01-2021

Didn't get your question.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

TMKAM · ‎10-04-2021

i have use your method but the message still appear even i select less than 6 month...

can you help to verify the scripts screenshot.

thank you

Lakshman12 · ‎07-22-2020

@asifnoor Checking if you can help me on this please.

Thanks

Lakshman

Vutikonda Vinay · ‎07-10-2023

Hey @Lakshman12, You can go with Catalog UI policies its a no code/low code and its worked for me.

Add catalog Ui policy condition as:

end_date - is more than - 6 - months - after - start_date

add script under run script.

For example take today as start date 07-10-2023 after 6 months(180 days after) end date is 01-06-2023.

In our catalog item end date will takes upto 6th jan and if put 7th jan or more than 7th jan, it will clears the end_date value and shows error message on the portal.

You can find screenshots attached

function onCondition() {
  g_form.clearValue('end_date');
  g_form.addErrorMessage('End date is not more than 180days');
}