BUG-000107585 for ArcGIS Pro

Bug ID Number	BUG-000107585
Submitted	August 24, 2017
Last Modified	June 5, 2024
Applies to	ArcGIS Pro
Version found	2.0
Operating System	Windows OS
Operating System Version	10.0 64 Bit
Status	Known Limit

Additional Information

This is an edge case where we attempt to determine the date format used in the .csv, but it fails because non of them are determinable (no day over 12, therefore we can't tell day from month). This failure causes us to fall back on the locale (for which none of the contained formats match) and we get nulls. Expanding the date fields to have days > 12 resolves the issue with .csv and .csv UTF-8. Once any date is distinguishable, we are able to apply the same algorithm to all of them.

Workaround

The documented workarounds are as follows:1. Use Excel spreadsheets instead of .csv files while working in a Swedish language environment.OR2. Change the operating system language to English.