Change sys_created_on date/time format from (yyyy-MM-dd HH:mm:ss) to (yyyy-MM-dd'T'HH:mm:ss.SSSZ)

[Community Alums]

How to Change/convert sys_created_on date/time format from (yyyy-MM-dd HH:mm:ss) to (yyyy-MM-dd'T'HH:mm:ss.SSSZ) in scoped application.

example:

2023-09-01 13:38:23

2023-09-06T07:46:06.523Z

[Cruz Melendi]

Hi,

This article might help you : https://www.servicenow.com/community/service-management-forum/how-to-convert-servicenow-ticket-creat...

This is one code you could use:

var incCreatedOn = current.getValue('sys_created_on');
var gdt = new GlideDateTime(incCreatedOn);
var createdOnDate = new Date(gdt.getNumericValue());
var isoDate = createdOnDate.toISOString();