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: [email protected]
Reporter: [email protected]
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.
