From 61173c1b58efa79c0ba6b08348d2796a249d0186 Mon Sep 17 00:00:00 2001 From: Norbert Thiebaud Date: Sat, 1 Sep 2012 09:51:27 -0500 Subject: move help structure one directory up Change-Id: Ie970e39fbb6795a92d9fdd13510409d7dcd071bc --- source/text/sbasic/shared/03030110.xhp | 155 +++++++++++++++++++++++++++++++++ 1 file changed, 155 insertions(+) create mode 100644 source/text/sbasic/shared/03030110.xhp (limited to 'source/text/sbasic/shared/03030110.xhp') diff --git a/source/text/sbasic/shared/03030110.xhp b/source/text/sbasic/shared/03030110.xhp new file mode 100644 index 0000000000..465e018dcf --- /dev/null +++ b/source/text/sbasic/shared/03030110.xhp @@ -0,0 +1,155 @@ + + + + + + + + +DateAdd Function [Runtime] +/text/sbasic/shared/03030110.xhp + + +DateAdd +checked + + + +
+DateAdd function + +DateAdd Function [Runtime] +Adds a date interval to a given date a number of times and returns the resulting date. +
+Syntax: +DateAdd (Add, Count, Date) +Return value: +A Variant containing a date. +Parameters: +Add - A string expression from the following table, specifying the date interval. +
+ + + +Add (string value) + + +Explanation + + + + +yyyy + + +Year + + + + +q + + +Quarter + + + + +m + + +Month + + + + +y + + +Day of year + + + + +w + + +Weekday + + + + +ww + + +Week of year + + + + +d + + +Day + + + + +h + + +Hour + + + + +n + + +Minute + + + + +s + + +Second + + +
+ +
+Count - A numerical expression specifying how often the Add interval will be added (Count is positive) or subtracted (Count is negative). +Date - A given date or the name of a Variant variable containing a date. The Add value will be added Count times to this value. +Example: +Sub example_dateadd +msgbox DateAdd("m", 1, "1/31/2004") &" - "& DateAdd("m", 1, "1/31/2005") +End Sub + + -- cgit