Wrong Timestamp
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?
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?
0
-
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.
-Josh0 -
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
Please sign in to leave a comment.
Comments
2 comments