Change date format to YYYY-MM-DD 00:00:00Z format

[Tapish Sharma]

Hi, 

User is entering the date from record producer in dd-mm-yyyy format. In backend I want the fields to be in the YYYY-MM-DD 00:00:00Z format. How can I achieve this ? 

[Ankur Bawiskar]

Glad to help.

Please mark response helpful as well.

Regards
Ankur

[Arshdeep Kaur1]

in flow then convert that and send

Sample script to convert normal date/time to ISO format

var myDate = '2022-02-21 00:00:00';
var gdt = new GlideDateTime();

var dt = gdt.getValue().split(' ');
var f = dt[0].split('-');
var t = dt[1].split(':');
var event = new Date(f[0], f[1]-1, f[2], t[0], t[1], t[2]);

var isoDate = event.toISOString();

gs.info(isoDate);

Regards

[Ankur Bawiskar]

Any specific reason you copied the same script which I shared and posted again?

[Hitoshi Ozawa]

ServiceNow will save datetime in yyyy-MM-dd HH:mm:ss format in server side.

Example:

var strDate = '02-02-2022';
var gdt = new GlideDateTime(strDate);
gs.info(gdt.getValue());

Execution result:

*** Script: 2022-02-02 00:00:00

[Hitoshi Ozawa]

That is, there's no need to do any conversion or scripting to save the date in yyyy-MM-dd HH:mm:ss format.