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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

This function adds timeToBeAdded to t and returns a NUMBER with the difference that weekends do not count in the sum.

Use negative values at timeToBeAdded for subtracting time from t.

Syntax
addTimeSkippingWeekends(number t, number timeToBeAdded, timeZone time_zone) #Output: Number
Examples
Parser expressionDescription

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
Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

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

NUMBER

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

TIMEZONE

The time zone used for the calculation. 

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. 

Output

The function returns a NUMBER with the difference that weekends do not count in the sum.


The function returns a NUMBER with a custom defined weekend.
beginning_of_weekend and end_of_weekend take the following values : {MONDAY} , {TUESDAY} ... {SUNDAY}.

Syntax
addTimeSkippingWeekends(number t, number timeToBeAdded, timeZone time_zone, number beginning_of_weekend, number end_of_weekend) #Output: Number
Examples
Parser expressionDescription
addTimeSkippingWeekends({...currentDateTime}, 12 * {HOUR}, LOCAL, {FRIDAY}, {SATURDAY})The function adds 12 hours to the current local time, and taking into consideration a weekend that begins with a Friday and ends with a Saturday.
Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

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

NUMBER

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

TIMEZONE

The time zone used for the calculation. 

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. 

Output

The function returns a NUMBER with a custom defined weekend.