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 29 Next »

This function adds or substracts natural days (or working days) to/from any given date. Weekends will not be counted as working days.


Syntax
addDaysSkippingWeekends(timestamp, numberOfDays, timeZone)
Examples
Parser expressionDescription
addDaysSkippingWeekends({issue.duedate}, 2, LOCAL)

This function adds 2 days to the TIMESTAMP of the issue due date . 

If the due date is set to a Monday the function will return a date-time for Wednesday.

If the due date is set to a Friday the function will return a date-time for Tuesday.

addDaysSkippingWeekends({issue.duedate}, -2, LOCAL)

This function substracts 2 days to the TIMESTAMP of the issue due date.

If the due date is set to a Monday the function will return a date-time for Thursday.

If the due date is set to a Friday the function will return a date-time for Wednesday.

addDaysSkippingWeekends({issue.cf10100}, -6, USER_LOCAL)

This function substracts 6 days from the TIMESTAMP of a custom date-time field (with the ID 10100).

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

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. 

Error rendering macro 'excerpt-include'

No link could be created for 'Dates, times and timezones'.

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

This function returns a timestamp represented as a NUMBER. 



TIMESTAMP equivalent of any given day plus an offset of n days where in a certain timezone weekends don't count.

addDaysSkippingWeekends(timestamp, sadasdsad, xxx)
Examples


Additional information

Parameter explanation....


Output

asdsadasdas


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.