DateAdd
Result = DateAdd ( Date as Date , Period AS Integer , Count AS Integer ) AS Date
Add a specific period to a given date.
-
Date is the initial date.
-
Period is the kind of period: year, month, day, week...
-
Count is the number of periods to add.
The resulting date is returned.
Period can be one of the following constants:
Examples
Dim date1 As Date = Date(1972, 09, 06, 1, 45, 0)
Dim date2 As Date = DateAdd(date1, gb.Minute, 45)
PRINT date1, date2
06.09.1972 01:45:00 06.09.1972 02:30:00
See also