This function adds or subtracts time to/from any given date.
Weekends will not be counted as working days.
addTimeSkippingWeekends(timestamp, timeToBeAdded, timeZone) #Output: Number
Parser expression | Description |
---|---|
addTimeSkippingWeekends({issue.duedate}, 1 * {MONTH} + 2 * {HOUR}, LOCAL) | This example adds 1 month and 2 hours to the issue's due date. Weekends won't be taken into account. |
addTimeSkippingWeekends({issue.created}, 3 * {DAY} + 1 * {HOUR}, LOCAL) | This example adds 3 days and 1 hour to the issue's creation date. Weekends won't be taken into account. |
addTimeSkippingWeekends({issue.duedate}, - 1 * {YEAR}, LOCAL) | This example subtracts 1 year from the issue's due date. Weekends won't be taken into account. |
Parameters used in this function
Parameter | Input (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). |
timeToBeAdded | NUMBER | The number defined here will be the offset of time. The offset can be set using various time macros. Learn more about time macros. Negative values are used to subtract time. |
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.
This function returns a NUMBER representing a timestamp..
The output can be written into any Jira field of type Date Picker or Date Time Picker.
Another very common use case is to use this function in a JWT calculated date-time field.
If you want to convert the number into a text, you might want to take a look at the dateTimeToString() function.
Variant of the function where you can additionally define the start and the end of the weekend.
addTimeSkippingWeekends(timestamp, timeToBeAdded, timeZone, startOfWeekend, endOfWeekend) #Output: Number
Parser expression | Description |
---|---|
addTimeSkippingWeekends({system.currentDateTime}, 12 * {HOUR}, LOCAL, {FRIDAY}, {SATURDAY}) | This example adds 12 hours to the current date and time. Fridays and Saturdays are not counted and will be skipped. |
addTimeSkippingWeekends({system.currentDateTime}, -2 * {DAY}, LOCAL, {SATURDAY}, {SUNDAY}) | This example subtracts 2 days from the current date and time. Saturdays and Sundays are not counted and will be skipped. |
Parameters used in this function
Parameter | Input (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). |
timeToBeAdded | NUMBER | The number defined here will be the offset of time. The offset can be set using various time macros. Learn more about time macros. Negative values are used to subtract time. |
timeZone | TIMEZONE | The time zone used for the calculation. |
startOfWeekend | NUMBER | The parameter will take values in the format of {MONDAY} , {TUESDAY} ... {SUNDAY} |
endOfWeekend | NUMBER | The parameter will take values in the format of {MONDAY} , {TUESDAY} ... {SUNDAY} |
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 NUMBER representing a timestamp.
The output can be written into any Jira field of type Date Picker or Date Time Picker.
Another very common use case is to use this function in a JWT calculated date-time field.
If you want to convert the number into a text, you might want to take a look at the dateTimeToString() function.