Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

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

Syntax
addMonths(timestamp, numberOfMonths, timeZone) #Output: Number
Examples
Parser expressionDescription
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, 202023:15 the output would be January 25th, 2020 23:15 (in milliseconds).

Additional information

Parameters used in this function

ParameterInput (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 number defined here will be the offset in moths. 

Negative values are used to substract days.

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
The 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 instead of adding.