Skip to main content
Solved

Converting columns in customer lists to date

  • 25 August 2021
  • 1 reply
  • 75 views

Forum|alt.badge.img+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. 

Best answer by tina

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 

View original
Did this post help you find an answer to your question?

1 reply

tina
RevenueCat Staff
Forum|alt.badge.img+10
  • RevenueCat Staff
  • 338 replies
  • Answer
  • August 24, 2021

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings