Date/Time results in Insights seem to be in UTC time zone

Question

Hi,

I started using ArcGIS Insights recently, and I love the functionality it offers.

But, something I noticed was - results seem to be in UTC time zone - when data is imported from a feature layer (not sure if this has only been happening since the latest ArcGIS Online update).

I also tested this by exporting the feature layer to a csv (where results are in UTC timezone by default) - and running the analysis in excel. And the date/time results were exactly the same as what was produced through ArcGIS Insights.

A fix on this would be greatly appreciated, or let me know if I'm doing anything wrong from my end.

Thanks so much,

Gee

Akshay Harshe · Answer

@CCGIS Can you please elaborate on your workflow/problem. Are you exporting a dataset in insights to a csv?

CCGIS · Answer

Hi ArcGIS Insights team,

I have a formatted table and the dates on my table can't be converted to date in Excel. I have tried different things and nothing seems to be working. From reading different posts, I understand the date is in UTC. How can I create a table so I can download the CSV with the correct date format?

Jon Emch · Answer

Geethaka Fernando,

Thanks for reaching out! Could you reply with a step by step workflow of how you are able to reproduce this issue? I went through a similar workflow and found that the UTC function worked as expected.

From my experimentation, I found that the UTC timecode can sometimes be based on whether or not you are linking to ArcGIS Online via a VPN. Are you able to reproduce this on a different internet connection / a different machine? Looking forward to your response.