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 11

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version 12

changes.mady.by.user Jona Ittermann

Saved on

Key

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


Page properties
hiddentrue



Status
Tech review

Status
titletodo

Style guide

Status
titletodo

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



Page properties
hiddentrue


Short descriptionTimestamp equivalent of any given day plus an offset of n days where weekends don't countThis function adds or subtracts month to/from any given date.
Output

Status
subtletrue
titletimestampnumber




  resultant of adding n months to timestamp tThis function adds or subtracts month to/from any given date.

UI Text Box
sizemedium
typeinfo

Returns a 

Status
subtletrue
titletimestamp


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



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


UI Expand
titleExamples


Parser expressionDescription


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


UI Text Box
typeinfo

timestamp t has {issue.duedate} has the value: March 25th, 2011 23:15


This function returns a timestamp as a 

Status
subtletrue
titlenumber
: June adds 3 months to the issue's due date. The return value would be June 25th, 2011 23:15 as number.


Code Block
languagebash
linenumberstrue
addMonths({issue.cf11025}, -2, USER_LOCAL)


UI Text Box
typeinfo

{issue.cf11025} has the value: March 25th, 2011 23:15


This function subtracts 2 months from the custom date-time field (with the ID 11025). The return value would be January 25th, 2011 23:15 as number.

Instead of the Jira server's local time this example uses the current user's time zone.



Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia
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).
numberOfDaysnumberOfMonths

Status
subtletrue
titlenumber

The number defined here will be the offset in daysmoths. 

Negative values are used to substract days.

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

timeZone

Status
subtletrue
titletimezone

The time zone used for the calculation. 

Expand
titleLearn more about timezones
Excerpt Include
Dates, times and time zonesDates, times and time zones
nopaneltrue
UI Text Box
typetip

. 



UI Expand
titleOutput
The function returns a
Status
subtletrue
titlenumber
 representing a timestamp.


UI Text Box
typenote

In this function we are not taking into consideration the fact that some months have more or less than 30 days.