Need a help in display of Date and time format in the incident form

Thrupthi
Tera Expert

How to change the date format form 2018-07-20 07:37:35 to 20/07/2018 08:37:35.

I have created script include and client script for UTC end field. UTC end will display the GMT date and time automatically when we select the Incident End date and time. But here when I select the Incident date, UTC end date and time is displaying in different format. please can somebody help on how to display the date format in 20/07/2018 08:37:35.

Client Script:

var ga = new GlideAjax('PGIncidentAJAX');
ga.addParam('sysparm_name', 'getGMT');
ga.addParam('sysparm_date_time', newValue);
ga.getXML(processResponse);

function processResponse(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
g_form.setValue('u_utc_end', answer); 
}

 

Server Script:

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

getGMT: function(){
var dt = this.getParameter('sysparm_date_time');
var gmt = new GlideDateTime();
// gmt.setStringParameter(dt.getByFormat("dd/MM/yyyy"));
gmt.setDisplayValue(dt);
return gmt;
},
type: 'PGIncidentAJAX'
});

 

 

1 ACCEPTED SOLUTION

I test below in my Dev instance and worked.

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

	getGMT: function(){
		var dt = this.getParameter('sysparm_date_time');
		var gdt = new GlideDateTime();
		gdt.setDisplayValue(dt);
		var date = gdt.getValue().split(' ');
		var dateonly = new GlideDate();
		dateonly.setValue(date[0]);
		var last = dateonly.getByFormat('dd/MM/yyyy') + " " + date[1];
		return last;
	},
	type: 'PGIncidentAJAX'
});

 

View solution in original post

20 REPLIES 20

lets log it.

var dt = this.getParameter('sysparm_date_time');
gs.log(dt.getDisplayValue(), "mike1");
var gdt = new GlideDateTime();
gdt.setValue(dt.getDisplayValue());
gs.log(gdt.getDisplayValue(), "mike2");
var date = gdt.getValue().split(' ');
var dateonly = new GlideDate();
dateonly.setValue(date[0]);
gs.log(dateonly.getDisplayValue(), "mike3");
var last = dateonly.getByFormat('dd/MM/yyyy') + " " + date[1];
gs.log(last, "mike4");
return last;

No Mike still the same "Undefined". 😞

 

Is there any way were below code can be changed just for the format

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

getGMT: function(){
var dt = this.getParameter('sysparm_date_time');
var gmt = new GlideDateTime();
// gmt.setStringParameter(dt.getByFormat("dd/MM/yyyy"));
gmt.setDisplayValue(dt);
return gmt;
},
type: 'PGIncidentAJAX'
});

Change it to this and lets see logs

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

	getGMT: function(){
		var dt = this.getParameter('sysparm_date_time');
		gs.log(dt.getDisplayValue(), "mike1");
		var gdt = new GlideDateTime();
		gdt.setValue(dt.getDisplayValue());
		gs.log(gdt.getDisplayValue(), "mike2");
		var date = gdt.getValue().split(' ');
		var dateonly = new GlideDate();
		dateonly.setValue(date[0]);
		gs.log(dateonly.getDisplayValue(), "mike3");
		var last = dateonly.getByFormat('dd/MM/yyyy') + " " + date[1];
		gs.log(last, "mike4");
		return last;
	},
	type: 'PGIncidentAJAX'
});

No Mike still undefined only

I test below in my Dev instance and worked.

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

	getGMT: function(){
		var dt = this.getParameter('sysparm_date_time');
		var gdt = new GlideDateTime();
		gdt.setDisplayValue(dt);
		var date = gdt.getValue().split(' ');
		var dateonly = new GlideDate();
		dateonly.setValue(date[0]);
		var last = dateonly.getByFormat('dd/MM/yyyy') + " " + date[1];
		return last;
	},
	type: 'PGIncidentAJAX'
});