Hi, I have a timestamp that I would like to convert to date. For example, 1605657600 is 11/18/2020. I used this formula to get to a string that could be converted to a date: =(((@TimeStampColumn/60)/60/24)+25569) and I got 44153. 25569 is a text of epoch time 1/1/1970. How can I convert 44153 to date now?
Date
Votes
1 comment
-
Hello
To convert an epoch or unix time to a date, use our Klipfolio Date functions. DATEVALUE would be easiest
https://support.klipfolio.com/hc/en-us/articles/215547988-DATE-and-DATEVALUE
For example:
DATEVALUE(1605657600,"MM/dd/yyyy")
Hope this helps,
Meggan
Please sign in to leave a comment.