[Libreoffice-bugs] [Bug 119009] the date and time functions do not work yet with the examples of their help pages

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Jul 30 21:34:55 UTC 2018


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

Xisco FaulĂ­ <xiscofauli at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |olivier.hallot at documentfoun
                   |                            |dation.org,
                   |                            |xiscofauli at libreoffice.org
          Component|Calc                        |Documentation
           Severity|normal                      |enhancement

--- Comment #1 from Xisco FaulĂ­ <xiscofauli at libreoffice.org> ---
It depends on the 'Date Acceptance pattern' defined in Tools - Options -
Language Settings - Languages.
In my case it's D/M/Y;D/M, so this works for me :
=DATEDIF("17/04/1974";"13/06/2012";"ym")

@Olivier, is it something we should mention in the help page ? ->
https://help.libreoffice.org/Calc/DATEDIF

-- 
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/20180730/20dba80c/attachment.html>


More information about the Libreoffice-bugs mailing list