From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/sbasic/shared/03030110.xhp | 157 +++++++++++++++++++++ 1 file changed, 157 insertions(+) create mode 100644 helpcontent2/source/text/sbasic/shared/03030110.xhp (limited to 'helpcontent2/source/text/sbasic/shared/03030110.xhp') diff --git a/helpcontent2/source/text/sbasic/shared/03030110.xhp b/helpcontent2/source/text/sbasic/shared/03030110.xhp new file mode 100644 index 000000000..f8768bd70 --- /dev/null +++ b/helpcontent2/source/text/sbasic/shared/03030110.xhp @@ -0,0 +1,157 @@ + + + + + + + DateAdd Function + /text/sbasic/shared/03030110.xhp + + + + + + +
+ + DateAdd function + + + +

DateAdd Function

+Adds a date or time interval to a given date a number of times and returns the resulting date. +
+ + + +DateAdd (interval As String, number As Long, date As Date) As Date + + +Return value: +A Variant containing a date. + + + interval - A string expression from the following table, specifying the date or time interval. + +
+ + + + + interval (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 + + +
+ +
+number - A numerical expression specifying how many times the interval value will be added when positive or subtracted when negative. +date - A given date or the name of a Variant variable containing a date. The interval value will be added number times to this date. + + + +Sub example_dateadd + MsgBox DateAdd("m", 1, #1/31/2004#) &" - "& DateAdd(date:=#2005-01-31#, interval:="m", number:=1) +End Sub + + + + \ No newline at end of file -- cgit v1.2.3