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

Versions Compared

Old Version 28

changes.mady.by.user Unknown User (sergio)

Saved on

compared with

New Version 29

changes.mady.by.user Iheb Kharab

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


UI Text Box
sizemedium
typeinfo

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


Code Block
languagebash
titleSyntax
linenumberstrue
addMonths(timestamp, numberOfMonths, timeZone) #Output: Number


UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue
addMonths({issue.dueDate}, 3, LOCAL)



This example adds 3 months to the issue's due date.

UI Text Box
typeinfo

If the due date was set to March 25th, 2020 23:15 the output would be June 25th, 202023:15 (in milliseconds).



Code Block
languagebash
linenumberstrue
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.

UI Text Box
typeinfo

If the custom field value was set to March 25th, 202023:15 the output would be January 25th, 2020 23:15 (in milliseconds).




UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

Status
subtletrue
titlenumber

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

Status
subtletrue
titlenumber

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

Status
subtletrue
titletimezone

The time zone used for the calculation. 



UI Expand
titleOutput

This function returns a

Status
subtletrue
titlenumber
 representing a timestamp


UI Text Box
typetip

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.



Image AddedUse cases and examples

Page properties report
firstcolumnUse case
headingsJWT feature, Workflow function, Field type, Automated action, Parser functions
cqllabel = "parser_func_addmonths" and space = currentSpace()


Page properties
hiddentrue



Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged



Page properties
hiddentrue


Short descriptionAdds or subtracts months to from any given date.
Output

Status
subtletrue
titlenumber

Label