https://bugs.documentfoundation.org/show_bug.cgi?id=140891
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #2 from Eike Rathke <er...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
