Milliseconds to Date

[gaurav_sandil]

Hi ,

I want to convert Milliseconds to Date.
For instance If I give 1540456849550 then it should give me the date like Thu 25 October 2018 14:10:49

Thanks,
Gaurav Sandil

[Anil]

@gaurav.sandil

Use below expression in mapper to achieve it.

Date.parse(1540456849550).toLocaleDateTimeString({“format”:“E dd MMMMM yyyy HH:mm:ss”})

[abirenzi]

Following expression in mapper worked for me. In case your millisec are in string format, parse them first in float then date:
Date.parse(parseFloat($endDateTime)).toLocaleDateString({“format”:“EEE, d MMM yyyy HH:mm:ss”})