[Libreoffice-commits] help.git: source/text
Steve Fanning (via logerrit)
logerrit at kemper.freedesktop.org
Thu May 20 23:18:03 UTC 2021
source/text/scalc/01/func_eomonth.xhp | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
New commits:
commit ab50f2ccc57ebe577cbdad4afa29b66317b87bcc
Author: Steve Fanning <stevemfanning at yahoo.co.uk>
AuthorDate: Thu May 20 21:43:42 2021 +0200
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Fri May 21 01:17:43 2021 +0200
Fix text in 2nd example given in help description of Calc's EOMONTH function.
The statement that the date MUST be in ISO format is not quite correct.
Also add link to updated wiki page.
Change-Id: I20158373f8a67ae90cd1bfccb9fbe1d7c011077f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115838
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
diff --git a/source/text/scalc/01/func_eomonth.xhp b/source/text/scalc/01/func_eomonth.xhp
index 186c4e948..74d3af592 100644
--- a/source/text/scalc/01/func_eomonth.xhp
+++ b/source/text/scalc/01/func_eomonth.xhp
@@ -40,8 +40,9 @@
<paragraph role="paragraph" id="par_id3154829" xml-lang="en-US">What is the last day of the month that falls 6 months after September 14 2001?</paragraph>
<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US"><item type="input">=EOMONTH(DATE(2001;9;14);6)</item> returns the serial number 37346. Formatted as a date, this is 2002-03-31.</paragraph>
-<paragraph role="paragraph" id="par_id3156144" xml-lang="en-US"><item type="input">=EOMONTH("2001-09-14";6)</item> works as well. If the date is given as string, it has to be in ISO format.</paragraph>
+<paragraph role="paragraph" id="par_id3156144" xml-lang="en-US"><item type="input">=EOMONTH("2001-09-14";6)</item> works as well. If you specify the date directly, we recommend using the standard ISO 8601 format because this should be independent of your selected locale settings.</paragraph>
<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id681621540307527"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH">EOMONTH wiki page</link></paragraph>
<embed href="text/scalc/01/04060102.xhp#datetimefunctions"/>
</section>
</body>
More information about the Libreoffice-commits
mailing list