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?

0

• 

  Josh Holnagel

  Employee

  • 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

Please sign in to leave a comment.