i want to convert the string to date and time format in flow designer transform functions

[rajamusani]

For the date alone i had used custom type with this value: yyyyMMdd it worked fine.

Please suggest if any body worked on date and time from the string field

2025-07-22 08:45:00

[Hemanth M1]

Hi @rajamusani ,

Why don't to just use GlideDateTime() api as below.

var dateString = "2024-07-22 08:30:00";  //sample string
var gdt = new GlideDateTime(dateString); 
gs.info(gdt.getDisplayValue()); //date time type output

[Hemanth M1]

HI @rajamusani ,

Hope, above solution met your requirement if so,

[Pranesh072]

You can use the custom format : yyyy-MM-dd '00:00:00'

or ServiceNow Date/time 

[rajamusani]

Hi Team,

Now i had changed to to the custom format yyyyMMddHHmmss, I will let you know after some testing results in my sub flow.

Thank you,

Rajasekhar