How to determine the date from 13 digit number timestamp from customer data

  • 23 December 2021
  • 1 reply

Badge +3

We exported all our customer data from the revenue cat customer tab. However under the sections first_seen_at, first_purchase, trial_start_at, etc it lists 13 digit numbers such as 1638562638000. How would we go about converting these timestamps into the date of the day?


Best answer by tina 27 December 2021, 17:52

View original

1 reply

Userlevel 5
Badge +10

Hey @Shervin 

In Excel, the formula is (A1/86400)+DATE(1970,1,1) where A1 is the corresponding cell. You can also double check some of the dates using an online converter: