Bug
When adding an item as Hosted Feature Service from a XLSX file, the date attribute values shift back by a day.
| Bug ID Number | BUG-000129988 |
|---|---|
| Submitted | April 8, 2020 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Online |
| Version found | 8.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
This is an expected behavior. When uploading data to ArcGIS Online without a specified time, the time is assumed to be 'midnight'. All data, unless specified via the upload process (ex. in ArcGIS Pro), is assumed to be in UTC. When viewing the data in a time zone with an earlier time than UTC, the data loses a day, or rather, lose a number of hours, based on the time difference. In this case, the data was published as UTC and viewed in Eastern Time Zone (which could appear as 4 or 5 hours backwards from UTC depending on the time of year). Therefore, 1/10 [midnight] would be seen as 1/9 [7 PM].Workaround
Workarounds include:
- Save as a XLS file.
- Use field calculator to add one to date field.
Steps to Reproduce
Bug ID: BUG-000129988
Software:
- ArcGIS Online
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