[Libreoffice-bugs] [Bug 140957] New: Date formatting is not unambiguous

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140957

            Bug ID: 140957
           Summary: Date formatting is not unambiguous
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: herman.viaene at edpnet.be

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210311/9a9dfe19/attachment.htm>