Skip to main content
Question

Epoch & Unix Timestamp Conversion


Is there a formula that will convert the Unix epoch time like '1555079067' to April 12, 2019 2:24:27 PM (GMT)
This topic has been closed for replies.

  • Registered
  • April 12, 2019
https://community.quickbase.com/quickbase/topics/how-to-format-a-date-returned-from-api

That post has what you need, sort of. It has the JavaScript that can do this. I just double checked it the code does work on quickbase still so they are still using/loading that library. It isn't as straight forward as just throwing that in a formula field though.

The relevant code from there is below. I will try and update this in a bit with how you might use it but this should get you started since you now know you have to use JavaScript. 

> $.datepicker.formatDate("mm/dd/yy", new Date( parseInt("1435579444018" ,10)) );