Purpose: The DateAdd() function allows you to increment a date by a chosen interval.
Usage: DateAdd(interval, number, date)
Interval may be set to:
- yyyy for year
- q for quarter
- m for month
- y for day of year
- d for day
- w for weekday
- ww for week
- h for hour
- n for minute
- s for second
Returns: Variant of type date containing the date incremented by number intervals.
Examples and Special Cases
DateAdd("yyyy", 1, "6-Nov-2006") returns "6-Nov-2007"
DateAdd("m", 1, "6-Nov-2006") returns "6-Dec-2006"
DateAdd("d", 1, "6-Nov-2006") returns "7-Nov-2006"
