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 1

changes.mady.by.user Christian Czaia

Saved on

compared with

New Version 2

changes.mady.by.user Christian Czaia

Saved on

Key

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

...

UI Text Box
sizemedium
typeinfo

Status
subtletrue
titleTimestamp
equivalent of any given day plus an offset of n days where weekends don't count.

expand



Syntax

...


Code Block
addDaysSkippingWeekends t, n, time_zone)


Info

If t represents a timestamp which coincides with a Friday, adding n = 1 will return a date-time for the following Monday.

Negative values for n are used in order to subtract days to t.

...

(warning) Note: n cannot be higher than 50000.

...

Syntax

Code Block
addDaysSkippingWeekends(number_1, number_2, time_zone)


Input data type(s)

status_namet: 

Status
subtletrue
titleTextnumber
 representing a timestamp
nschedule_name: 
Status
string
subtletrue
titlenumber
 representing the number of days
time_zone: 
Status
subtletrue
titletimezone

Output

Status
subtletrue
titlenumber

Examples


UI Expand
titleShow examples


Code Block
timeInStatus("Open", "my_schedule", LOCAL)

Number of milliseconds the current issue has stayed in status "Open" within the schedule called "my_schedule" matching the server's default timeZone.

Code Block
timeInStatus("Open", "my_schedule", LOCAL)

Number of milliseconds the current issue has stayed in status "Open" within the schedule called "my_schedule" matching the server's default timeZone.

Code Block
timeInStatus("Open", "my_schedule", LOCAL)

Number of milliseconds the current issue has stayed in status "Open" within the schedule called "my_schedule" matching the server's default timeZone.


...