Skip to main content
Question

Epoch & Unix Timestamp Conversion

  • Apr 12, 2019 6:28 PM UTC
  • 0 replies
  • 190 views

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.

  • Qrew Colonel
  • Apr 12, 2019 8:29 PM UTC
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)) );