add-months-to-date

Adds the specified number of months to a given date.

Syntax

    add-months-to-date(strDate1, months)

Parameters

strDate1 is a string that represents the date and is specified in the format yyyy-mm-dd. For more information about date and time parameters, see Date and time parameters.

months is a number that holds the number of months to add to the given date. A negative number for months subtracts months from the given date.

Returns

A string value in the format yyyy-mm-dd.

Example

The following expression returns a string value of 2000-10-28:

add-months-to-date('1999-11-28',11)