From Mike Chapple,
Your Guide to Databases.
FREE Newsletter. Sign Up Now!

Function: DateAdd()

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"