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

Tapish Sharma · ‎02-21-2022

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 · ‎02-21-2022

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

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

View solution in original post

Tapish Sharma · ‎02-21-2022

Thank you Hitoshi

Vidhi Jindal · ‎02-21-2022

Backend field is of type string?

you can convert dd-mm-yyyy to ISO format easily and store it using record producer script

how are you mapping it currently?