Result = DateAdd ( Date as Date , Period AS Integer , Count AS Integer ) AS Date
Add a specific period to a given date.
Period can be one of the following constants:
Constant | Effect |
---|---|
gb.second | Adds seconds. |
gb.minute | Adds minutes. |
gb.hour | Adds hours. |
gb.day | Adds days. |
gb.week | Adds weeks. |
gb.weekday | Adds week days (ignore Saturday and Sunday). |
gb.month | Adds months. |
gb.quarter | Adds quarters. |
gb.year | Adds years. |
date1 = Date(1972, 09, 06, 1, 45, 0) date2 = DateAdd(date1, gb.Minute, 45) PRINT date1, date2
06.09.1972 01:45:00 06.09.1972 02:30:00