Time format Conversion changing the date

[Shrabanti]

I am doing date conversion. But not sure why it is changing the date.

Input Date is : “29-JUN-21 10.07.35.000000 AM”
Output date is becoming :“2020-12-27 10:07:35”

The conversion I am using is :
Date.parse($OrderDetailCreateDate,“dd-MMM-YY hh.mm.ss.SSSSSS aa”).toLocaleDateTimeString( { “format”:“yyyy-MM-dd HH:mm:ss” } )

[Sowmya_Rayavara]

Hi Shrabanti,

Can you please try with the below date function? Just changed the year format ‘YY’ to ‘yy’

Date.parse(“29-JUN-21 10.07.35.000000 AM”,“dd-MMM-yy hh.mm.ss.SSSSSS aa”).toLocaleDateTimeString( { “format”:“yyyy-MM-dd HH:mm:ss” } )

[bojanvelevski]

Hi @Shrabanti ,

Your expression looks good, and only needs 2 changes. Year should be lowercase letters, and Hours should be uppercase. The expression needs to look like this:

Date.parse('29-JUN-21 10.07.35.000000 AM','dd-MMM-yy HH.mm.ss.SSSSSS aa').toLocaleDateTimeString( { "format":"yyyy-MM-dd HH:mm:ss" } )

@Sowmya_Rayavarapu’s expression is nearly identical, and also works.

Regards,
Bojan