Microsoft Access DateAdd Function
Category: Microsoft Access Date Functions
Applies to: Microsoft® Access® 2013, 2016, 2019 and 365 (Windows Desktop)
The Microsoft Access DateAdd function adds a time or date interval to a date and then returns the date.
DateAdd (interval, number, date)
The Interval parameter is a required time or date interval to be added to a specific date (such as year or month using codes).
Use the following codes (in quotes):
yyyy = year
q = quarter
m = month
y = day of the year
d = day
w = Weekday
ww = Week
h = hour
n = Minute
s = Second
The number parameter is a required number and is the interval to add to date. The number can be positive for dates in the future or negative for dates in the past.
The date parameter is a required date (typically a date field) to which the interval is added.
The following 3 examples refer to either a date field and function or functions (you may enter function names and field names in lower case):
Calculate a date 6 months from a date:
Calculate a date 1 year from a date:
Calculate a date 15 days before the current date (the Date function is used here for the current date):
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at email@example.com if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
You may like
You can highlight values in fields or records in Microsoft Access reports using conditional formatting. Certain conditions must be met in order for the formatting to be applied …
You may also like
If you are working in Gantt Chart view, you can use these keyboard shortcuts to quickly move and select in your task list.
Check out these great ways to zoom and pan in your Microsoft Visio diagrams quickly using your mouse and keyboard.
Check out these 10 great Microsoft Visio shortcuts for selecting common tools in the Ribbon including the Pointer, Text tools and drawing tools.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | firstname.lastname@example.org