Forum Discussion
- AustinKQrew Commanderhttps://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)) );- JIMLIEDER1Qrew CadetSending new Contacts entered in HubSpot to QuickBase using Zapier. Want to display the date & time the contact was created in HubSpot. The Contact transaction date & time is in Unix timestamp like '1555079067'
- DanielJohnson2Qrew Trainee
For anyone looking at this in the post-JavaScript era:
ToTimestamp(Date(1970,1,1))+Seconds([UNIX Time])
------------------------------
Daniel Johnson
------------------------------