How to convert Unix Time to Normal

Hi, I am doing an integration on ClickUp with Google sheets, and I need to convert Unix timestam to Normal.

I do the following {{formatDate(parseDate(1.date; “X”); “MM/DD/YYYY”)}}
However, it doesn’t return the correct value.

Please let me know what am I doing wrong.
Знімок екрана 2024-02-24 162213
Знімок екрана 2024-02-24 162108

Welcome to the Make community!

19835735 is not a valid Unix timestamp.

Looks like this is in seconds.

A Unix timestamp is in milliseconds, so you need to multiply this number by 1000 first.

2 Likes

Thank you for your reply.

I have checked the value without any formulas, and it returns a correct Unix Timestamp value (2nd screenshot), but when I try to parse it (without formating), it gives me this value (1st screenshot).

And when I add format, it gives me the value that I attached earlier.


Знімок екрана 2024-02-25 092229

Oh, are you inserting into Google sheets? Then you might just be able to format the entire column of cells as date format, directly in Google sheets itself.

2 Likes

Maybe you are right, and that will be easier, just wanted to do that on make, thank you!