View Source

	Status
Tech review
Style guide

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

This function adds or substracts natural days (or working days) to/from any given date.

Weekends will not be counted as working days.

addDaysSkippingWeekends(timestamp, numberOfDays, timeZone) #Output: Number

Parser expression

Description

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

This function adds 2 working days to the 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 working days from the 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 working days from the 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.

Parameters used in this function

Parameter Input (data type) Description

timestamp

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

numberOfDays

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

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.

This function returns a representing a timestamp.

The output can be written into any Jira field of type Date Picker ore Date Time Picker.

Another very common use case is to use this function in a JWT calculated date-time field.

Variant of the function where you can define the start and the end of the weekend .

This function is useful when the non-working days differ from the standard (Saturday/Sunday).

addDaysSkippingWeekends(timestamp, numberOfDays, timeZone, startOfWeekend, endOfWeekend) #Output: Number