Solved

Converting columns in customer lists to date

  • 25 August 2021
  • 1 reply
  • 56 views

Badge +3

I am trying to look at when users start a free trial cancel the subscription. I exported a customer list from RevenueCat and have been looking at the data in Excel. In Excel the columns that I am looking at are  trial_opt_out_at and trial_start_at. Does anyone know how to convert the values in these columns to dates from the numbers that they are set. Currently the values in these columns look like - 1629693003000. 

icon

Best answer by tina 25 August 2021, 00:20

View original

1 reply

Userlevel 5
Badge +10

Hi @ABHINAV DUBEY!

Those columns are epoch timestamp in milliseconds.  RevenueCat documentation for reference: https://docs.revenuecat.com/docs/customer-lists#exporting-data There’s an article online that would help convert these to a readable date: https://www.extendoffice.com/documents/excel/4696-excel-milliseconds-to-date.html 

Reply