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.
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.
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.
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.
Maybe you are right, and that will be easier, just wanted to do that on make, thank you!
