summaryrefslogtreecommitdiff
path: root/source/text/sbasic/shared/03030120.xhp
diff options
context:
space:
mode:
authorAlain Romedenne <alain.romedenne@libreoffice.org>2021-03-17 18:08:22 +0100
committerRafael Lima <rafael.palma.lima@gmail.com>2021-03-24 14:30:15 +0100
commit1b6dd9ef516340ceeef990671ea1571b70794d0e (patch)
tree2451033111d1be2b93a8e5754505cbad7d635fd8 /source/text/sbasic/shared/03030120.xhp
parent234c4c4faf76533586563f828fc6d533eeac8bc1 (diff)
Basic DateXXX methods
- Fix to Basic DateXxx examples - Locale independant date literals documentation - keywords arguments examples Change-Id: I906b035bb687e6164c6b296f50449986414fa756 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/112616 Tested-by: Jenkins Reviewed-by: Rafael Lima <rafael.palma.lima@gmail.com>
Diffstat (limited to 'source/text/sbasic/shared/03030120.xhp')
-rw-r--r--source/text/sbasic/shared/03030120.xhp28
1 files changed, 14 insertions, 14 deletions
diff --git a/source/text/sbasic/shared/03030120.xhp b/source/text/sbasic/shared/03030120.xhp
index fdcbbcc61e..e1e8a2c894 100644
--- a/source/text/sbasic/shared/03030120.xhp
+++ b/source/text/sbasic/shared/03030120.xhp
@@ -33,31 +33,31 @@
<bookmark_value>DateDiff function</bookmark_value>
</bookmark>
-
-<paragraph id="par_idN10542" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03030120.xhp">DateDiff Function</link></paragraph>
-<paragraph id="par_idN10546" role="paragraph" xml-lang="en-US">Returns the number of date intervals between two given date values.</paragraph>
+<h1 id="par_idN10542" xml-lang="en-US"><link href="text/sbasic/shared/03030120.xhp">DateDiff Function</link></h1>
+<paragraph id="par_idN10546" role="paragraph" xml-lang="en-US">Returns the number of date or time intervals between two given date values.</paragraph>
</section>
-<paragraph id="par_idN10549" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
-<paragraph id="par_idN10648" role="bascode" xml-lang="en-US">DateDiff (Add, Date1, Date2 [, Week_start [, Year_start]])</paragraph>
+<paragraph id="par_idN10648" role="bascode" xml-lang="en-US">DateDiff (interval As String, date1 As Date, date2 As Date [, firstDayOfWeek As Integer [, firstWeekOfYear As Integer]]) As Double</paragraph>
</bascode>
<paragraph id="par_idN1064B" role="heading" level="2" xml-lang="en-US">Return value:</paragraph>
<paragraph id="par_idN1064F" role="paragraph" xml-lang="en-US">A number.</paragraph>
-<paragraph id="par_idN10652" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph>
-<paragraph id="par_idN10656" role="paragraph" xml-lang="en-US"> <emph>Add</emph> - A string expression from the following table, specifying the date interval.</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
+<paragraph id="par_idN10656" role="paragraph" xml-lang="en-US"> <emph>interval</emph> - A string expression from the following table, specifying the date or time interval.</paragraph>
<embed href="text/sbasic/shared/03030110.xhp#datetable"/>
-<paragraph id="par_idN10664" role="paragraph" xml-lang="en-US"> <emph>Date1, Date2</emph> - The two date values to be compared.</paragraph>
+<paragraph id="par_idN10664" role="paragraph" xml-lang="en-US"> <emph>date1, date2</emph> - The two date values to be compared.</paragraph>
+<embed href="text/sbasic/shared/01020100.xhp#DateLiterals"/>
<section id="weekyear">
-<paragraph id="par_idN1066A" role="paragraph" xml-lang="en-US"> <emph>Week_start</emph> - An optional parameter that specifies the starting day of a week. </paragraph>
+<paragraph id="par_idN1066A" role="paragraph" xml-lang="en-US"> <emph>firstDayOfWeek</emph> - An optional parameter that specifies the starting day of a week. </paragraph>
<table id="tbl_id8356883">
<tablerow>
<tablecell>
- <paragraph id="par_idN1067A" role="tablehead" xml-lang="en-US">Week_start value</paragraph>
+ <paragraph id="par_idN1067A" role="tablehead" xml-lang="en-US">firstDayOfWeek value</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10680" role="tablehead" xml-lang="en-US">Explanation</paragraph>
@@ -129,12 +129,12 @@
</tablerow>
</table>
-<paragraph id="par_idN106EB" role="paragraph" xml-lang="en-US"> <emph>Year_start</emph> - An optional parameter that specifies the starting week of a year. </paragraph>
+<paragraph id="par_idN106EB" role="paragraph" xml-lang="en-US"> <emph>firstWeekOfYear</emph> - An optional parameter that specifies the starting week of a year. </paragraph>
<table id="tbl_id1173436">
<tablerow>
<tablecell>
- <paragraph id="par_idN106FB" role="tablehead" xml-lang="en-US">Year_start value</paragraph>
+ <paragraph id="par_idN106FB" role="tablehead" xml-lang="en-US">firstWeekOfYear value</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_idN10701" role="tablehead" xml-lang="en-US">Explanation</paragraph>
@@ -176,10 +176,10 @@
</section>
-<paragraph id="par_idN10738" role="heading" level="2" xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341501344" role="bascode" localize="false" xml-lang="en-US">Sub example_datediff</paragraph>
-<paragraph id="par_idm1341500112" role="bascode" localize="false" xml-lang="en-US"> MsgBox DateDiff("d", "1/1/2005", "12/31/2005")</paragraph>
+<paragraph id="par_idm1341500112" role="bascode" localize="false" xml-lang="en-US"> MsgBox DateDiff("d", #1/1/2005#, #2005-12-31#)</paragraph>
<paragraph id="par_idm1341498848" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph>
</bascode>
</body>