You are here:
ADDMONTHS
Returns the date that is the indicated number of months before or after a specified date. If the specified date is the last day of the month, the resulting date is the last day of the resulting month. Otherwise, the result has the same date component as the specified date.
Use
ADDMONTHS (date,
num) and replace date with the start date and
num with the number of months to be added.
Generic Example
ADDMONTHS (StartDate,
5)
Adds 5 months to the start date. For example, if the start date is September 20, 2017, the resulting date is February 20, 2018, If the start date is September 30, 2017, the resulting date is February 28, 2018.
Did this article solve your issue?
Let us know so we can improve!
