I need to convert a Timestamp field (L) into a date format

Hi!
I need to convert this field (L) into a date format but I cannot do that:

image

I have tried with Unixe timestamp to date&time node but it does not work:

image

Can you help me?
Thanks
Giad

Hi giad,

Unix timestamp is without milliseconds, your given timestamps obviously with. Just divide it before converting it.

–Philipp

The node is the correct one.
When looking on the Unix timestamp (1603991183127) it may be in milli seconds.
I assume that you tried to handle the timestamp in seconds as this fits to the year of the output.

Please ensure that you select in the node settings the correct unit (millseconds)

HTH

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.