Default date format changed from DD.MM.YYYY to YYYY.MM.DD in CSV import (since 0.81.1) – data corruption risk

[wparuch]

Describe the bug
After updating to version 0.81.1, the application started supporting new date formats when importing from CSV. However, when importing a CSV file with the DD.MM.YYYY date format (previously the default), the application now assumes a different default format (YYYY.MM.DD). This leads to incorrect date parsing and data corruption. The issue was not immediately apparent, resulting in damaged data. Please restore DD.MM.YYYY as the default or add a parser that automatically detects and applies the correct format.

To Reproduce

1. Go to 'File' -> 'Import' -> 'CSV files'
2. Select a CSV file where dates are in the DD.MM.YYYY format
3. Complete the import process
4. Observe that the dates are incorrectly parsed as YYYY.MM.DD

Expected behavior
Dates in DD.MM.YYYY format should be correctly recognized and imported as such, either by restoring this as the default or by automatically detecting the format.

Screenshots

Desktop (please complete the following information):

• OS: macOS
• Version: 0.81.2
• Language: polish

Additional context
This change can lead to silent data corruption, especially for users who have been using the DD.MM.YYYY format for years.