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)
|
|
|