Wrong Timestamp

JHandler

September 27, 2017 03:16

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?

Comments

2 comments

Josh Holnagel

September 28, 2017 13:57
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
0
JHandler

September 28, 2017 20:45
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.
0