addMonths()

This function adds or subtracts months to or from any given date.

Syntax

addMonths(timestamp, numberOfMonths, timeZone) #Output: Number

Examples

Parser expression	Description
addMonths({issue.dueDate}, 3, LOCAL)	This example adds 3 months to the issue's due date. If the due date was set to March 25th, 2020 23:15 the output would be June 25th, 202023:15 (in milliseconds).
addMonths({issue.cf11025}, -2, USER_LOCAL)	This example subtracts 2 months from the custom date-time field (with the ID 11025). Instead of the Jira server's local time this example uses the current user's time zone. If the custom field value was set to March 25th, 2020 23:15 the output would be January 25th, 2020 23:15 (in milliseconds).

Additional information

Parameters used in this function

Parameter Input (data type) Description

timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).

numberOfMonths

NUMBER

The offset in moths. Negative values are used to subtract moths.

Internally JWT multiplies this value with the time macro {MONTH} to add full days to the timestamp. Learn more about time macros.

timeZone

TIMEZONE

The time zone used for the calculation.

Output

This function returns a NUMBER representing a timestamp

Use this function instead of simply adding n * {MONTH}, since {MONTH} is a macro equivalent to 30 * {DAY }, not taking into account that there are months with 31/28/29 days.

Negative values for n are used in order to subtract.

Use cases and examples

Use case	JWT feature	Workflow function	Field type	Automated action	Parser functions
Set a date two months after the end of the quarter		Update or copy field values			nextTime() addMonths()
Create a sub-task for every recurring deadline within a task		Create issue			addMonths() getMatchingValue() dateToString()

Content

Space Tools

Parameters used in this function

Use cases and examples