1. Home
  2. Computing & Technology
  3. Databases

Microsoft Access Function Library: DateAdd()

By Mike Chapple, About.com

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"
Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. Microsoft Access
  5. Access Function Library
  6. Microsoft Access Function Library: DateAdd()>

©2009 About.com, a part of The New York Times Company.

All rights reserved.