Wrong Timestamp

  • 1
  • Problem
  • Updated 1 year ago
When we download the analytics, the timestamp makes no sense. I just downloaded it now 9:14PM 9/25 and one of the users timestamps is shows 9/26/17 0:41
Which is in the future. Can the timestamp be set to our timezone EST rather than UTC which is very confusing for our end users?
Photo of Joel Handler

Joel Handler

  • 2 Posts
  • 1 Reply Like
  • frustrated

Posted 1 year ago

  • 1
Photo of Josh Holnagel

Josh Holnagel, Employee

  • 424 Posts
  • 78 Reply Likes
Hi Joel,

Thanks for posting this. We've done some investigating, and here's what we've found.

We currently use a third party service (Microsoft Azure) to store analytics data. Azure stores that data in the UTC time format, so that format is the only format available.

I did find an Excel formula for converting timestamps from one time zone to another. I know this is less than ideal, but it's the best I can offer at this time. Link: https://excelribbon.tips.net/T010739_Converting_UTC_Times_to_Local_Times.html

I'm sorry for the confusion this is causing.

-Josh
Photo of Joel Handler

Joel Handler

  • 2 Posts
  • 1 Reply Like
This may be fine for me, a Tech Director, but is not a real solution I can give to a classroom teacher or Principal who wants to use this software.   Azure should have mechanisms to convert the timestamp on download.