What is the Date Format for Exports?

Avatar
  • updated
  • Under review

I routinely download my data to run more advanced analytics.  I can't seem to find out how your csv treats dates in the Created At, Completed At etc. columns.  They come out at long numeric digits like 635774037729699000.  How do I make sense of that? How can I convert to actual date and time.

App:
Web app
Pinned replies
Avatar
Ana Loraine
  • Answer

Hi, Ryan!


Thank you for patiently waiting.


Our dev team has identified this as a minor bug and they are working on fixing this issue.


As for the conversion to the actual date and time, you may refer to this link:


http://tickstodatetime.com/


We will notify you once we have an update on this issue.


Thank you for understanding.

Avatar
Ana Loraine
  • Under review

Hi there!


Thank you for reaching out.


I reached out to our dev team for this information. i will get back to you as soon as I receive a feedback.


Thank you for understanding.

Avatar
Ana Loraine
  • Answer

Hi, Ryan!


Thank you for patiently waiting.


Our dev team has identified this as a minor bug and they are working on fixing this issue.


As for the conversion to the actual date and time, you may refer to this link:


http://tickstodatetime.com/


We will notify you once we have an update on this issue.


Thank you for understanding.