1

I frequently have to export data from a layer in ArcGIS online (that is created from Arc Collector offsite) to excel via CSV format. One of the fields is the CreationDate field that is automatically created when a layer is used. Every time I download the layer and export to excel, the time is always incorrect: seven hours are added to each correct time. For example, a time in excel reads 21:30 when it should read 14:30. The time zone and format for all equipment used is the same, so I am not sure what is happening when the data is exported.

  • What does the time look like when you open the csv with notepad? (to rule out Excel manipulating the data) – kttii Jun 29 '16 at 19:38
  • AGOL using same time zone all over the world. – FelixIP Jun 29 '16 at 19:42
  • Its showing the incorrect times in notepad – matthiastrek Jun 29 '16 at 20:10
  • We have this same issue, i thought i even posted a question on it awhile back but i couldnt find it (maybe it was on geonet.) I have heard from the esri rep that this issue will be resolved in 10.5, they told us a workaround would be the geoevent processor, but we dont currently use that. I have been dying for this to be fixed for ages. – ed.hank Apr 28 '17 at 16:10
2

The time output is in UTC which is the time the database is in. UTC is the basis for local times worldwide and is the default used in geodatabases and in the databases hosted data from ArcGIS Online is in.

And this post in quora can help you convert the time to your timezone in excel

https://www.quora.com/In-Excel-how-do-I-convert-data-into-a-different-timezone

Just a simple math equation and remember to have your field set as date or it will automatically format it as a numeric field.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.