CSV File Import mangles dates - locale?
Open
bug report
- Dominant language
- Python
- Stars
- 5.7k
- Forks
- 1.1k
- Avg merge
- 12d 2h
- Merged PRs (30d)
- 1
Description
**What's wrong?**
Importing a csv file with UK dates and leaving the type to 'auto' results in some dates being converted to American format (those where the date is less than 13) and others not. I could set the type to 'text' but then the column order is re-arranged, which is also not ideal.
**How can we reproduce the problem?**
Import a column containing e.g. "28/03/18" and "08/03/18"
"28/03/18" becomes 2018-03-28
"08/03/18" becomes 2018-08-03
**What's your environment?**
- Operating system: Linux - OpenSUSE Tumbleweed
- Orange version: 3.35
- How you installed Orange:
Orange3 installation was via pip
Contributor guide
Assessment
This issue has not been assessed yet.