biolab / biolab/orange3

CSV File Import mangles dates - locale?

Open
#6,499 2 comments 0 reactions 1 assignee Claimed by @PrimozGodec View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.