glideRecord getDisplayValue(sys_created_on) get only Year, Month and Day not Hours and Minutes

Elton2
Tera Contributor

Hi everyone, good afternoon!

I'm doing a glideRecord in the "sys_created_on" field in the "sc_req_item" table, but I only need to show: Year, Month and Danot Hours and Minutes (attached image).

 

Server:

var createdNew = todoLineRecordGr.getDisplayValue('sys_created_on');
data.createdNew = createdNew ? createdNew : "created new test";

 

HTML:

<h1>Created at: {{::data.createdNew}}</h1>

 

Obs.: There's glide_date_time, but I'm not understanding how to use!

 

Could anybody help me?

 

Tks

1 ACCEPTED SOLUTION

Bert_c1
Kilo Patron

Here is an example script:

var inc = new GlideRecord('incident');
inc.query();
if (inc.next()) {
	var recDateTime = inc.sys_created_on.getDisplayValue();
	gs.info("Inc: " + inc.number + " was created on " + recDateTime + ".");
	var dateArray = recDateTime.split(" ");
	gs.info("Date = " + dateArray[0] + ", time = " + dateArray[1] + ".");
}

and you can use:

https://developer.servicenow.com/dev.do#!/reference/api/sandiego/server/no-namespace/c_APIRef#r_Scop...

View solution in original post

2 REPLIES 2

Bert_c1
Kilo Patron

Here is an example script:

var inc = new GlideRecord('incident');
inc.query();
if (inc.next()) {
	var recDateTime = inc.sys_created_on.getDisplayValue();
	gs.info("Inc: " + inc.number + " was created on " + recDateTime + ".");
	var dateArray = recDateTime.split(" ");
	gs.info("Date = " + dateArray[0] + ", time = " + dateArray[1] + ".");
}

and you can use:

https://developer.servicenow.com/dev.do#!/reference/api/sandiego/server/no-namespace/c_APIRef#r_Scop...

Elton2
Tera Contributor

Hi Bert!

Thanks for your support! Its working!!!

Att