Bug
When exporting the results from the Query widget in ArcGIS Experience Builder, all timestamp fields on the resulting CSV are transformed from local time into UTC and from 12-hour time to 24-hour time.
| Bug ID Number | BUG-000157122 |
|---|---|
| Submitted | March 30, 2023 |
| Last Modified | August 5, 2025 |
| Applies to | ArcGIS Experience Builder |
| Version found | February 2023 |
| Operating System | Windows OS |
| Operating System Version | N/A |
| Status | Known Limit |
Additional Information
ArcGIS Online stores date fields in UTC, applying a conversion to the local time when displaying the date fields based on the machine's time zone settings. Exporting to a CSV file exports the stored UTC time for date fields, as outlined in ArcGIS Online documentation: https://doc.arcgis.com/en/arcgis-online/reference/csv-gpx.htm#:~:text=Data%20is%20exported%20in%20UTC%20format.Workaround
Either use ArcGIS Web AppBuilder (where CSV exports return time stamps in local or 12-hour time) or recalculate the time from UTC (24-hour) to local (12-hour) outside of ArcGIS Online after exporting the CSV.
Steps to Reproduce
Bug ID: BUG-000157122
Software:
- ArcGIS Experience Builder
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App