Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8? Click here and leave these dusty old pages behind!
Availability
This routine is available starting with SIL Engine™ 2.5.5.
Syntax
addMonths(date, noMonths)
Description
Adds a number of months to a specified date, preserving the day of month where possible.Parameters
Parameter name | Type | Required | Description |
---|---|---|---|
date | date | Yes | Specifies a Date expression. |
noMonths | number | Yes | Number of months to add. If given a negative number, will do subtract. |
Return type
date
Example
function addMonthsInDesc(date d, int noMonths){ desc += "Date " + d + " + " + noMonths + " months = " + addMonths(d, noMonths) + "\n"; } desc = ""; addMonthsInDesc("2012-01-31", 1); addMonthsInDesc("2012-04-30", -2); addMonthsInDesc("2013-01-31", 1); addMonthsInDesc("2013-04-30", -2); addMonthsInDesc("2012-01-31", 12); addMonthsInDesc("2012-01-31", -1);
Outputs to description:
Date 2012-01-31 00:00:00 + 1 months = 2012-02-29 00:00:00
Date 2012-04-30 00:00:00 + -2 months = 2012-02-29 00:00:00
Date 2013-01-31 00:00:00 + 1 months = 2013-02-28 00:00:00
Date 2013-04-30 00:00:00 + -2 months = 2013-02-28 00:00:00
Date 2012-01-31 00:00:00 + 12 months = 2013-01-31 00:00:00
Date 2012-01-31 00:00:00 + -1 months = 2011-12-31 00:00:00
See also