[Libreoffice-bugs] [Bug 143947] New: Function DATE yields wrong year if input is only "year"

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143947
           Summary: Function DATE yields wrong year if input is only
                    "year"
           Product: LibreOffice
           Version: 7.1.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: flavius.chiriac at gmail.com

When using the DATE function which requires inputs (Year;Month;Day), omitting
one or two inputs (i.e. Month/Day or both) yields incorrect output.

Is this by design? 
Explanation would help, otherwise it's a bug, no?

Examples:
=DATE(2006;;) -> 2005-11-30 incorrect / bug?!
=DATE(2006;1;) -> 2005-12-31 incorrect / bug?!
=DATE(2006;;1) -> 2005-12-01 incorrect / bug?!
=DATE(2006;1;1) -> 2006-01-01 correct

Reproducable: new document

As usual, please link to duplicates or solutions etc., online search did
however not easily find something.

Thanks, Greets

-- 
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/20210818/291685c9/attachment.htm>