Bug
Importing an Excel file with a date field in ArcGIS Business Analyst does not maintain the date values or date format, and instead displays a number which is not associated with the date.
| Bug ID Number | BUG-000138198 |
|---|---|
| Submitted | March 16, 2021 |
| Last Modified | September 16, 2024 |
| Applies to | ArcGIS Business Analyst Web App |
| Version found | 8.4 |
| Operating System | Windows OS |
| Operating System Version | 10.0 |
| Status | Non-Reproducible |
Additional Information
The behavior is no longer reproducible in the latest version of ArcGIS Business Analyst Web App. After importing an Excel file which includes a date field, the date values are formatted when viewing attributes in the web app. Contact Technical Support if the issue persists.Workaround
- Save the Excel file as a CSV file and add the data displays the correct dates in the attribute table and pop-up window.
- Create a hosted feature layer in ArcGIS Online from the Excel file and import it to ArcGIS Business Analyst displays the correct dates.
Steps to Reproduce
Bug ID: BUG-000138198
Software:
- ArcGIS Business Analyst Web App
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