How to set Date Variable in MM/dd/YYYY format using onChange Client Script

Shraddha Kadam
Mega Sage

Hello All,

On the RITM form I want to update the date variable. When I update the date variable the date is in the 'yyyy/dd/MM' format. I want the date variable is in the 'MM/dd/yyyy' format using onChange client script.

Anyone please help me.

I will appreciate the response.

Thank you.

If my response was helpful, please mark it as correct and helpful.
Thank you.
1 ACCEPTED SOLUTION

@Shraddha Kadam 

GlideAjax Example

Use this script include and send the value which is in yyyy/dd/MM format

var MyConversion = Class.create();
MyConversion.prototype = {
	initialize: function() {
	},

	convertDateFormat: function(){

		var incomingDate = this.getParameter('sysparm_format') + ' 00:00:00';
		var format = 'yyyy/dd/MM HH:mm:ss';
		var gdt = new GlideDateTime();
		gdt.setDisplayValue(incomingDate,format);
		var gd = new GlideDate(); 
		gd.setValue(gdt.getDate());
		return gd.getByFormat("MM/dd/yyyy");

	},

	type: 'MyConversion'
};

Regards
Ankur

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

View solution in original post

15 REPLIES 15

@Ankur Bawiskar 

I have requirement to set the date variable as 'MM/dd/yyyy' format. However when I update the RITM form the date is in 'yyyy/dd/MM' format. 

How to covert into 'MM/dd/yyyy' format ? using onChange Client script. 

Thank You.

If my response was helpful, please mark it as correct and helpful.
Thank you.

Hi,

you can use string manipulation as easiest approach

OR

You need to use onChange Client Script with GlideAjax

Regards
Ankur

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

@Ankur Bawiskar 

Thanks for the reply !!

Could you please share your script.

I will appreciate your response !!

Thank You.

If my response was helpful, please mark it as correct and helpful.
Thank you.

@Shraddha Kadam 

GlideAjax Example

Use this script include and send the value which is in yyyy/dd/MM format

var MyConversion = Class.create();
MyConversion.prototype = {
	initialize: function() {
	},

	convertDateFormat: function(){

		var incomingDate = this.getParameter('sysparm_format') + ' 00:00:00';
		var format = 'yyyy/dd/MM HH:mm:ss';
		var gdt = new GlideDateTime();
		gdt.setDisplayValue(incomingDate,format);
		var gd = new GlideDate(); 
		gd.setValue(gdt.getDate());
		return gd.getByFormat("MM/dd/yyyy");

	},

	type: 'MyConversion'
};

Regards
Ankur

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

Thanks !! Its Worked !!

If my response was helpful, please mark it as correct and helpful.
Thank you.