Convert string to Timestamp

[ashis1upreti]

• Hello everyone, 

can someone please help convert string  “20240311113047” into TIMESTAMP format? Thank you!

[AleksandarAngel]

Hello @ashis1upreti,

You can try by using the Date.parse() function in a Mapper Snap.

In your case, as a second argument you need to provide the format in which the date is in.

Date.parse("20240311113047","yyyyMMddhhmmss")

Also, you can take a look at the Date.toLocaleDateTimeString() function if you want to format the date.

Please let me know if this helps you.

Regards,

Aleksandar.