Versions Compared

Key

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


Page properties



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 count.
Output

Status
subtletrue
titlenumber



UI Text Box
sizemedium
typeinfo

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


Syntax

Code Block
linenumberstrue
addDaysSkippingWeekends t, n, time_zone)


UI Text Box
typeinfo

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

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


UI Text Box
typenote

Note(warning) Noten cannot be higher than 50000.


Input

ParameterData typeDescription
t

Status
subtletrue
titlenumber

timestamp returned by a custom field or 
n

Status
subtletrue
titlenumber

Number of days to be added
time_zone

Status
subtletrue
titletimezone

Timezone which will be used to base the calculation on


Output

This expression will return a timestamp as a 

Status
subtletrue
titlenumber

Examples

Parser expressionDescription


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.





Syntax


Code Block
addDaysSkippingWeekends t, n, time_zone)


Info

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

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

(warning) Noten cannot be higher than 50000.


Input data type(s)

t: 

Status
subtletrue
titlenumber
 representing a timestamp
n: 
Status
subtletrue
titlenumber
 r
epresenting 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.