tdf#131332: Replace custom date formats with ISO 8601

Change-Id: Idf08d44bb5287da44b281820e73e08c58e154f99
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178163
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
(cherry picked from commit 22c587639a5c06e9a61a390b4ea18da0cb0c0b68)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/178184

5 files changed, 6 insertions, 6 deletions

diff --git a/source/text/sbasic/shared/03030101.xhp b/source/text/sbasic/shared/03030101.xhp
index 0d5af98e14..b0a5aa4f79 100644
--- a/source/text/sbasic/shared/03030101.xhp
+++ b/source/text/sbasic/shared/03030101.xhp
@@ -49,7 +49,7 @@
 <paragraph role="paragraph" id="par_id3151043" xml-lang="en-US">
 <emph>Day:</emph> Integer expression that indicates the day of the specified month. The accepted range is from 1-31. No error is returned when you enter a non-existing day for a month shorter than 31 days.<comment>see i69463</comment></paragraph>
 <paragraph role="paragraph" id="par_id3161832" xml-lang="en-US">The <emph>DateSerial function</emph> returns the number of days between December 30,1899 and the given date. You can use this function to calculate the difference between two dates.</paragraph>
-<paragraph role="paragraph" id="par_id3155306" xml-lang="en-US">The <emph>DateSerial function</emph> returns the data type Variant with VarType 7 (Date). Internally, this value is stored as a Double value, so that when the given date is 1.1.1900, the returned value is 2. Negative values correspond to dates before December 30, 1899 (not inclusive).</paragraph>
+<paragraph role="paragraph" id="par_id3155306" xml-lang="en-US">The <emph>DateSerial function</emph> returns the data type Variant with VarType 7 (Date). Internally, this value is stored as a Double value, so that when the given date is 1900-01-01, the returned value is 2. Negative values correspond to dates before December 30, 1899 (not inclusive).</paragraph>
 <paragraph role="paragraph" id="par_id3152576" xml-lang="en-US">If a date is defined that lies outside of the accepted range, $[officename] Basic returns an error message.</paragraph>
 <paragraph role="paragraph" id="par_id3149481" xml-lang="en-US">Whereas you define the <emph>DateValue function</emph> as a string that contains the date, the <emph>DateSerial function</emph> evaluates each of the parameters (year, month, day) as separate numeric expressions.</paragraph>
 <embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
diff --git a/source/text/sbasic/shared/03100300.xhp b/source/text/sbasic/shared/03100300.xhp
index 2308773913..0ea1043d6c 100644
--- a/source/text/sbasic/shared/03100300.xhp
+++ b/source/text/sbasic/shared/03100300.xhp
@@ -53,8 +53,8 @@
 <embed href="text/sbasic/shared/00000003.xhp#functexample"/>
 <bascode>
   <paragraph id="par_idm1341009312" role="bascode" localize="false" xml-lang="en-US">Sub ExampleCDate</paragraph>
-  <paragraph id="par_idm1341008080" role="bascode" localize="false" xml-lang="en-US">    MsgBox cDate(1000.25) ' 09.26.1902 06:00:00</paragraph>
-  <paragraph id="par_idm1341006816" role="bascode" localize="false" xml-lang="en-US">    MsgBox cDate(1001.26) ' 09.27.1902 06:14:24</paragraph>
+  <paragraph id="par_idm1341008080" role="bascode" localize="false" xml-lang="en-US">    MsgBox cDate(1000.25) ' 1902-09-26 06:00:00</paragraph>
+  <paragraph id="par_idm1341006816" role="bascode" localize="false" xml-lang="en-US">    MsgBox cDate(1001.26) ' 1902-09-27 06:14:24</paragraph>
   <paragraph id="par_idm1341005552" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph>
 </bascode>
 <section id="relatedtopics">
diff --git a/source/text/sbasic/shared/03102300.xhp b/source/text/sbasic/shared/03102300.xhp
index ff2a1f0b3f..d3a04b2e64 100644
--- a/source/text/sbasic/shared/03102300.xhp
+++ b/source/text/sbasic/shared/03102300.xhp
@@ -55,7 +55,7 @@
 <bascode>
 <paragraph id="par_idm1340791552" role="bascode" localize="false" xml-lang="en-US">Sub ExampleIsDate</paragraph>
 <paragraph id="par_idm1340790320" role="bascode" localize="false" xml-lang="en-US">Dim sDateVar As String</paragraph>
-<paragraph id="par_idm1340789088" role="bascode" localize="false" xml-lang="en-US">    sDateVar = "12.12.1997"</paragraph>
+<paragraph id="par_idm1340789088" role="bascode" localize="false" xml-lang="en-US">    sDateVar = "1997-12-12"</paragraph>
 <paragraph id="par_id31508692102" role="bascode" localize="false" xml-lang="en-US">    Print IsDate(sDateVar) ' True</paragraph>
 <paragraph id="par_idm1340786096" role="bascode" localize="false" xml-lang="en-US">    sDateVar = "12121997"</paragraph>
 <paragraph id="par_id31472883695" role="bascode" localize="false" xml-lang="en-US">    Print IsDate(sDateVar) ' False</paragraph>
diff --git a/source/text/scalc/01/02140600.xhp b/source/text/scalc/01/02140600.xhp
index 15584eeb39..791573ffe3 100644
--- a/source/text/scalc/01/02140600.xhp
+++ b/source/text/scalc/01/02140600.xhp
@@ -81,7 +81,7 @@
 <h3 id="hd_id3150202">AutoFill</h3>
 <paragraph id="par_id3156288" role="paragraph"><ahelp hid="modules/scalc/ui/filldlg/autofill">Forms a series directly in the sheet.</ahelp> The <emph>AutoFill</emph> function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
 </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Sort Lists</emph>.</paragraph>
-<paragraph id="par_id3155811" role="paragraph">AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used.</paragraph>
+<paragraph id="par_id3155811" role="paragraph">AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 1999-01-01 and 1999-01-15, an interval of 14 days is used.</paragraph>
 <paragraph id="par_id2956483" role="paragraph" localize="false"><embedvar href="text/scalc/guide/calc_series.xhp#calc_series"/></paragraph>
 
 <h2 id="hd_id3148700">Unit of Time</h2>
diff --git a/source/text/swriter/00/00000404.xhp b/source/text/swriter/00/00000404.xhp
index 2c8bbed237..776a273133 100644
--- a/source/text/swriter/00/00000404.xhp
+++ b/source/text/swriter/00/00000404.xhp
@@ -35,7 +35,7 @@
 <section id="insert_field">
 	<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
 	<paragraph role="paragraph" id="par_id3154654">Choose <menuitem>Insert - Field</menuitem></paragraph>
-	<comment>Fields do not have context menus (15.01.20)</comment>
+	<comment>Fields do not have context menus</comment>
 	<embed href="text/shared/00/00000004.xhp#from_context"/>
 	<paragraph role="paragraph" id="par_id3146966">Open context menu - choose <menuitem>Edit Field</menuitem> (inserted fields)</paragraph>
 	<embed href="text/shared/00/00000004.xhp#from_tabUI"/>