Previous Topic

Next Topic

AddMonths - SQL Function

AddMonths(Date: Date, Months: Number[, ForceDay as Number]): Date

AddMonths adds the number of Months specified to Date. If ForceDay is not specified the result will be the date in the new month closest to the original day specified. If ForceDay is specified the results will be a date in the new month closest to ForceDay.

AddMonths function syntax has these named arguments:

Parameter

Description

Date

Required. Date to add the months to.

Months

Required. Number of months to add to the Date.

Force Day

Optional. Select the day value for the return date. If not entered, the result will be a date in the new month closest to the day specified in Date.

See Also

SQL Date Functions

Book Contents

Book Index