add-months-to-dateTime

Adds the specified number of months to a given date and time.

Syntax

    add-months-to-dateTime(strDateTime1, months)

Parameters

strDateTime1 is a string that represents the date and time, and is specified in the format yyyy-mm-ddThh:mm:ssZ. 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 and time. A negative number for months subtracts months from the given date and time.

Returns

A string value in the format yyyy-mm-ddThh:mm:ssZ.

Example

The following expression returns a string value of 2000-10-28T11:12:00Z:

add-months-to-dateTime('1999-11-28T11:12:00Z',11)