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
Describe in detail step by step what you are doing, what is the expected result, and what is the actual result
Created attachment 174037 [details]
source of data
Created attachment 174038 [details]
calc linked to testdates.odb
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"
Version: 18.104.22.168.alpha0+ (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
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).