[Libreoffice-bugs] [Bug 143947] 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

--- Comment #2 from Henrik Palomäki <henrik.palomaki at yandex.com> ---
It seems a value in DATE function defaults to 0 if no number is given. It seems
MS Excel acts in the same way.

Should the default value be 1 instead of 0? In that case the expected result
for the all given examples should be 2006-01-01.

Currently, the value 0 in DATE function gives the previous value of 1 that is
12 for the case of month and in the case of day it is the last day of previous
month.

-- 
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/20210819/e8029283/attachment.htm>