MS Access DateAdd() 函数

将两年添加到指定日期：

SELECT DateAdd("yyyy", 2, #22/11/2017#);

定义和用法

DateAdd() 函数将时间/日期间隔添加到日期，然后返回日期。

DateAdd( interval, number, date)

Parameter	Description
interval	Required. The time/date interval to add. Can be one of the following values: yyyy = Year q = Quarter m = month y = Day of the year d = Day w = Weekday ww = Week h = hour n = Minute s = Second
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

工作于：	从 Access 2000