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

Anoja · ‎02-21-2022

Hi,

Go to Profile in instance and change the date format.

Ankur Bawiskar · ‎02-21-2022

Hi,

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?

Regards
Ankur

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

Tapish Sharma · ‎02-21-2022

Hi Ankur ,

It is of Date/Time type

Ankur Bawiskar · ‎02-21-2022

the format which is displayed depends on user's date format,

if target field is of date/time then why to convert?

You can directly map the date/time variable to that target field and it should work fine.

Regards
Ankur

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