Bug 140957 - Date formatting is not unambiguous
Summary: Date formatting is not unambiguous
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2021-03-11 15:15 UTC by herman.viaene
Modified: 2021-08-04 03:48 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

source of data (2.94 KB, application/vnd.oasis.opendocument.database)
2021-08-03 08:17 UTC, herman.viaene
calc linked to testdates.odb (8.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-08-03 08:18 UTC, herman.viaene

Note You need to log in before you can comment on or make changes to this bug.
Description herman.viaene 2021-03-11 15:15:27 UTC
Storing peoples birthdates in Base is messy.
I have an application where we store peoples birthdays in a date field in a table. It happens that we have a very wide range of dates. In our case 1917 and 2015.
I tried to change the date options but
1. I cannot switch off the two digit interpretation (currently 1930 - 2029) 
2. in the language setting (Dutch Belgium) the mask DD/MM/YYYY is not accepted

The messy thing is that if I do the input e.g. 22/01/1917 it stores it OK, I can use the table as a source for Calc and subtract the year from today() correctly, but everywhere it shows the date as 22/01/17, so I cann't see the difference between 22/01/1917 and 22/01/2017
Comment 1 Maria Grishanova 2021-08-02 18:14:29 UTC
Describe in detail step by step what you are doing, what is the expected result, and what is the actual result
Comment 2 herman.viaene 2021-08-03 08:17:10 UTC
Created attachment 174037 [details]
source of data
Comment 3 herman.viaene 2021-08-03 08:18:07 UTC
Created attachment 174038 [details]
calc linked to testdates.odb
Comment 4 herman.viaene 2021-08-03 08:27:55 UTC
I created a small testdates.odb containing one table "persons" with a name and birthday field. Note that the birtday date is formatted  'DD/MM/YYYY' and you see the full dates in the table. The database is registered.
Note also that I am working with Dutch-Belgium as overall language setting in LO.
The file testdat.ods contains just a link to this persons table. Note the the data is displayed "DD/MM/YY" and there is no way I can change that format in the language setting. So I cann't see the difference between 1917 and 2017.
Of  course I can change the display format of these cells, but as soon as I reopen the file and renew the data source, the format goes back to "DD/MM/YY"
Comment 5 Maria Grishanova 2021-08-03 18:54:15 UTC
repro in

Version: (x64) / LibreOffice Community
Build ID: 7c38362dbe1922c9825dffb463072030948d406b
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: en-US (ru_RU); UI: en-US
Calc: CL

When copying a table from a database, the date format changes. In the database DD/MM/YYYY, in a table becomes DD/MM/YY. This happens regardless of the format of the cell in the database (Text or Date).