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?
Answer
How to determine the date from 13 digit number timestamp from customer data
+4Best answer by tina
Hey
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: https://www.epochconverter.com/
This post has been closed for comments
+10Hey
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: https://www.epochconverter.com/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.