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 tinaView original
In Excel, the formula is
A1is the corresponding cell. You can also double check some of the dates using an online converter: https://www.epochconverter.com/