โ08-26-2021 01:17 AM
Hi All,
I am trying change a date format with expression.
Input is a string value: โ04/23/2021 12:00:00 AMโ
Output should be โyyyy-MM-dd HH:mm:ssโ format
I am trying data parse the incoming date format but unable find proper format for input date.
Date.parse($CertActivityDate,โmm/dd/yyyy hh:mm:ss AMโ).toLocaleDateTimeString( { โformatโ:โyyyy-MM-dd HH:mm:ssโ } )
Could you please siggest.
โ08-26-2021 01:22 AM
Hi @Shrabanti,
Use the following expression:
Date.parse("04/23/2021 12:00:00 AM","MM/dd/yyyy HH:mm:ss a").toLocaleDateTimeString({"format":"yyyy-MM-dd HH:mm:ss"})
Regards,
Bojan
โ08-26-2021 01:53 AM
@bojanvelevski Thank you it worked.
Could you please also point me where I can see all different time formats.
Thanks & Regards,
Shrabanti
โ08-26-2021 02:04 AM
โ08-26-2021 08:22 AM