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).
No repro Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community Build ID: ff2ba77f22b2e96f96f5537aec1705956b47583d CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL In this version of LibreOffice, the format dd/mm/yyyy in Dutch (Belgium) is accepted.
Idem with Version: 7.3.8.0.0+ (x64) / LibreOffice Community Build ID: e1ad83ddb2f39419fb5d7c69eba51e2b9f49c788 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL
Created attachment 188376 [details] no problem with the format of the date No repro Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 229123ccc6f90ebf66b3e659bebbd53f8a9bdd3a CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL
Tested with 7.4.5.1: problem does not reproduce anymore.