Bug 140957 - Date formatting is not unambiguous
Summary: Date formatting is not unambiguous
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-03-11 15:15 UTC by herman.viaene
Modified: 2023-08-01 07:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
source of data (2.94 KB, application/vnd.oasis.opendocument.database)
2021-08-03 08:17 UTC, herman.viaene
Details
calc linked to testdates.odb (8.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-08-03 08:18 UTC, herman.viaene
Details
no problem with the format of the date (1.31 MB, image/gif)
2023-07-14 12:55 UTC, Sophie Sipasseuth
Details

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
Hello. 
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: 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).
Comment 6 Sophie Sipasseuth 2023-07-14 12:44:26 UTC
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.
Comment 7 Sophie Sipasseuth 2023-07-14 12:46:39 UTC
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
Comment 8 Sophie Sipasseuth 2023-07-14 12:55:02 UTC
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
Comment 9 herman.viaene 2023-07-14 12:59:48 UTC
Tested with 7.4.5.1: problem does not reproduce anymore.