Forum Discussion

Re: Epoch & Unix Timestamp Conversion

Sending 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' 

1 Reply

  • DanielJohnson2's avatar
    DanielJohnson2
    Qrew Trainee

    For anyone looking at this in the post-JavaScript era:

    ToTimestamp(Date(1970,1,1))+Seconds([UNIX Time])



    ------------------------------
    Daniel Johnson
    ------------------------------