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
Hello. 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"
repro in Version: 7.3.0.0.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 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).