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 2

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version 3

changes.mady.by.user Iheb Kharab

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 description
Timestamp equivalent of any given day plus an offset of n days where weekends don't count.

Adds timeToBeAdded to t and returns a

Status
subtletrue
titlenumber

Output

Status
subtletrue
titlenumber




UI Text Box
sizemedium
typeinfo

This function adds timeToBeAdded to t and returns a

Status
subtletrue
titlenumber
with the difference that weekends do not count in the sum.


UI Text Box
typetip

Use negative values at timeToBeAdded for subtracting time from t.


Code Block
languagebash
titleSyntax
linenumberstrue
addTimeSkippingWeekends(number t, number timeToBeAdded, timeZone time_zone) #Output: Number


UI Expand
titleExamples


Parser expressionDescription


UI Text Box
typeinfo

t represents a date-time which coincides with a Saturday

timeToBeAdded = 2 * {HOUR}

The function will return a date-time for next Monday at 02:00



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).
numberOfDays
Output

Status
subtletrue
titlenumber

The number defined here will be the offset in days. 

Negative values are used to substract days.

Internally JWT multiplies this value with the time macro  {DAY} 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 zones
Dates, times and time zones
nopaneltrue



UI Text Box
typetip

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.