diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2017-08-19 20:15:09 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@edx.srv.br> | 2017-08-20 19:57:23 +0200 |
| commit | c399dc47d92de039391f4962df355f632ce10d05 (patch) | |
| tree | 0aa70a1919bcf2c729b850955bfa10e12a219968 /source/text/sbasic | |
| parent | 26259f880a5978290ae1a9da300025a73c702a63 (diff) | |
tdf#106957 - outdated doc for BASIC date functions
Change-Id: Icb1266d36696f3f6c4cbfff0aa467b6304af9a33
Reviewed-on: https://gerrit.libreoffice.org/41343
Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Diffstat (limited to 'source/text/sbasic')
| -rw-r--r-- | source/text/sbasic/shared/03030102.xhp | 5 | ||||
| -rw-r--r-- | source/text/sbasic/shared/03100300.xhp | 5 |
2 files changed, 4 insertions, 6 deletions
diff --git a/source/text/sbasic/shared/03030102.xhp b/source/text/sbasic/shared/03030102.xhp index 8308ce5278..47c25f6b56 100644 --- a/source/text/sbasic/shared/03030102.xhp +++ b/source/text/sbasic/shared/03030102.xhp @@ -43,10 +43,7 @@ <paragraph role="paragraph" id="par_id3153194" xml-lang="en-US">Date<comment>i66764</comment></paragraph> <paragraph role="heading" id="hd_id3153969" xml-lang="en-US" level="2">Parameters:</paragraph> <paragraph role="paragraph" id="par_id3153770" xml-lang="en-US"> -<emph>Date:</emph> String expression that contains the date that you want to calculate. The date can be specified in almost any format.</paragraph> -<paragraph role="paragraph" id="par_id3153189" xml-lang="en-US">You can use this function to convert a date that occurs between December 1, 1582 and December 31, 9999 into a single integer value. You can then use this value to calculate the difference between two dates. If the date argument lies outside the acceptable range, $[officename] Basic returns an error message.</paragraph> -<paragraph role="paragraph" id="par_id3146974" xml-lang="en-US">In contrast to the DateSerial function that passes years, months, and days as separate numeric values, the DateValue function passes the date using the format "month.[,]day.[,]year".</paragraph> -<embed href="text/sbasic/shared/00000003.xhp#languageformat"/> +<emph>Date:</emph> String expression that contains the date that you want to calculate. In contrast to the DateSerial function that passes years, months and days as separate numeric values, the DateValue function requests the date string to be according to either one of the date acceptance patterns defined for your locale setting (see <item type="menuitem">Tools - Options - Language Settings - Languages</item>) or to ISO date format (momentarily, only the ISO format with hyphens, e.g. "2012-12-31" is accepted).</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> <paragraph role="heading" id="hd_id3153142" xml-lang="en-US" level="2">Example:</paragraph> diff --git a/source/text/sbasic/shared/03100300.xhp b/source/text/sbasic/shared/03100300.xhp index 9a68f74324..294c0220b7 100644 --- a/source/text/sbasic/shared/03100300.xhp +++ b/source/text/sbasic/shared/03100300.xhp @@ -48,7 +48,8 @@ <paragraph id="hd_id3153525" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> <paragraph id="par_id3150359" role="paragraph" xml-lang="en-US"> <emph>Expression:</emph> Any string or numeric expression that you want to convert.</paragraph> -<paragraph id="par_id3125864" role="paragraph" xml-lang="en-US">When you convert a string expression, the date and time must be entered in the format MM.DD.YYYY HH.MM.SS, as defined by the <emph>DateValue</emph> and <emph>TimeValue</emph> function conventions. In numeric expressions, values to the left of the decimal represent the date, beginning from December 31, 1899. Values to the right of the decimal represent the time.</paragraph> +<paragraph id="par_id3125864" role="paragraph" xml-lang="en-US">When you convert a string expression, the date and time must be entered + either in one of the date acceptance patterns defined for your locale setting (see <item type="menuitem">Tools - Options - Language Settings - Languages</item>) or in ISO date format (momentarily, only the ISO format with hyphens, e.g. "2012-12-31" is accepted). In numeric expressions, values to the left of the decimal represent the date, beginning from December 31, 1899. Values to the right of the decimal represent the time.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> @@ -61,4 +62,4 @@ </bascode> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |