HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
Add two years to a specified date
The DateAdd() function adds a time/date interval to a date and then returns the date.
DateAdd(interval, number, date)
Parameter | Description |
---|---|
interval | Required. The time/date interval to add. Can be one of the following values:
|
number | Required. The number of interval to add to date. Can be positive (to get dates in the future) or negative (to get dates in the past) |
date | Required. The date to which the interval should be added |
Works in: | From Access 2000 |
---|
Add one year to the current system date:
SELECT DateAdd("yyyy", 1, Date());
Add 6 months to the employees' birth date:
SELECT LastName, DateAdd("m", 6, BirthDate) FROM Employees;