[Libreoffice-bugs] [Bug 140891] Function MONTH does not properly display the correct information

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
The MONTH() result *is* 3 but you can't format that result as date and expect
it would display March, same as with any number 3. Instead, it displays the
date for "3 days since null date", which for the null date 1899-12-30 happens
to be 1900-01-02 so for your MMM-YY format you get Jan-00.

Just use =NOW() and format it to MMM-YY if that is what you want.

-- 
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/20210308/404fa344/attachment.htm>