Time format Conversion changing the date

Question

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 · Answer

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 · Answer

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

Forum Discussion

Time format Conversion changing the date

2 Replies

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?