Validation on date/time type variable on catalog item

[Sanket Choughul]

Hi Community,

I have 2 variables named-

Required date and expired date. The requirement is that maximum selectable 'expired date' should be 'required date' + 3 months. Can someone help me with this?

[OlaN]

Hi,

Read this article, it can help you

[Abhijit4]

Hi Sanket,

There is no way to compare dates on client side script. You need to write onChange client script on expired date field and use GlideAjax to get Date Difference.

Below thread will help you with more clarification

Find difference between two dates

In above thread, they sent date difference to client side then you can use code like if difference is more than 90 days then throw error else no error.

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

Thanks and Regards,
Abhijit

[Service_RNow]

HI,

Below is the script include code:-

var myDateUtil = Class.create();
myDateUtil.prototype = Object.extendsObject(AbstractAjaxProcessor, {
	getEndDate:function()
	{
		var dt1=this.getParameter('sys_parm_issue_dt');
		var how_many_months=this.getParameter('sys_parm_how_many_months');
		var dt=new GlideDateTime(dt1);
		dt.addMonthsLocalTime(parseInt(how_many_months));
		return dt.getDate();
	},

    type: 'myDateUtil'
});

Below is the onChange client script date field:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
	if (isLoading) {
		return;
	}
	if(newValue === '')
	{
		g_form.clearValue('end_date');
	}
	var ga = new GlideAjax('myDateUtil'); 
	ga.addParam('sysparm_name','getEndDate'); 
	ga.addParam('sys_parm_issue_dt',newValue); 
	ga.addParam('sys_parm_how_many_months',3); 
	ga.getXML(cb);  

	// the callback function for returning the result from the server-side code
	function cb(response) {  
		var answer = response.responseXML.documentElement.getAttribute("answer"); 
		if(answer)
		g_form.setValue('end_date',answer);
	}


	//Type appropriate comment here, and begin script below

}

Please mark this as Correct or Helpful if it helps.

Thanks
RS

[Lovely1]

Hi @Sanket Choughule 

You can achieve this using before update BR also and set conditions as per your requirement. Below is script:

You can replace field names with your own field names.

(function executeRule(current, previous /*null when async*/ ) {

var end_date = current.u_end_date;
var start_date = current.u_start_date;

var gd = new GlideDateTime(start_date);
gd.addMonthsLocalTime(3);

var date = gd.getDate();

if (date != end_date) {

gs.addErrorMessage('Should be +3 minths to start Date');
current.setAbortAction(true);

}

Thanks,

Lovely.