Page History

Versions Compared

Old Version 26

changes.mady.by.user Christian Czaia

Saved on Mar 04, 2020

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on Nov 15, 2021

Key

This line was added.
This line was removed.
Formatting was changed.

Page properties

hidden	true

Status

Tech review

Status

title	todo

Style guide

Status

title	todo

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Page properties

hidden	true

Short descriptionThis function returns a timestamp equivalent of any given day plus an offset of n days where weekends don't count.Output

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

This function returns a timestamp equivalent of any given day plus an offset of n days. Weekends will not count as extra days so this function returns regular working days. adds or subtracts natural days (or working days) to or from any given date.

Weekends will notbecounted as working days.

code

Code Block

language	bash


title	Syntax
linenumbers	true

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

UI Expand

title	Examples

Parser expression

Description

Code Block

linenumbers	true

addDaysSkippingWeekends({issue.

duedate

dueDate}, 2, LOCAL)

This

function returns the

Status

subtle	true
title	Timestamp

of the issue due date + 2 days

example adds 2 working days to the issue's 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.

Code Block

linenumbers	true

addDaysSkippingWeekends({issue.

duedate

dueDate}, -2, LOCAL)

This

function returns the

Status

subtle	true
title	Timestamp

of the issue due date - 2 days.

example subtracts 2 working days from the issue's 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.

Code Block

linenumbers	true

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

This

function returns the

Status

subtle	true
title	Timestamp

example subtracts 6 working days from of a custom date-time field (with the ID 10100)

- 6 working days

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

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

timestamp

Status

subtle	true
title	number

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

numberOfDays

Status

subtle	true
title	number

The

number defined here will be the

offset in days. Negative values are used to subtract days.

Internally JWT multiplies this value with the time macro {DAY} to add full days to the timestamp. Learn more about time macros.

Negative values are used to substract days.

timeZone

Status


subtle	true
title	timezone

The

timezone

time zone used for the calculation.

UI Text Box

type	tip

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.

Learn more about working with dates, times and timezones.

Output

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

representing a timestampasdsadasdas

UI Text Box

Info

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.

Note: n cannot be higher than 50000.

size	medium
type	info

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

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

Code Block

language	bash
title	Syntax
linenumbers	true

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

Examples

UI Expand

title	Examples

Parser expression

Description

Code Block

linenumbers	true

addDaysSkippingWeekends({issue.dueDate}, 10, LOCAL, {FRIDAY}, {SATURDAY})

This example adds 10 working days to the issue's due date.

Fridays and Saturdays are not counted and will be skipped.

UI Text Box

size	medium
type	info

Status

subtle	true
title	Timestamp

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

Code Block

linenumbers	true

addDaysSkippingWeekends(

timestamp

{issue.dueDate}, -2, LOCAL,

sadasdsad

{SUNDAY},

xxx)

UI Expand

{TUESDAY})

This example subtracts 2 working days from the issue's due date.

Sundays, Mondays and Tuesdays are not counted and will be skipped..

title

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

timestamp

Status

subtle	true
title	number

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

numberOfDays

Status

subtle	true
title	number

The offset in days. Negative values are used to subtract 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


subtle	true
title	timezone

The time zone used for the calculation.

startOfWeekend

Status

subtle	true
title	number

Valid values are {MONDAY}, {TUESDAY} ... {SUNDAY}.

endOfWeekend

Status

subtle	true
title	number

Valid values are {MONDAY}, {TUESDAY} ... {SUNDAY}.

UI Text Box

type	tip

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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

representing a timestamp

UI Text Box

type	tip

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 one of the JWT calculated date-time fields.

If you want to subtract two date-time values you might want to have a look at the function subtractDatesSkippingWeekends().

Image AddedUse cases and examples

Page properties report

firstcolumn	Use case
headings	JWT feature, Workflow function, Field type, Automated action, Parser functions
cql	label = "parser_func_adddaysskippingweekends" and space = currentSpace()

Page properties

hidden	true

Status

Tech review

Status

colour	Green
title	done

Style guide

Status

colour	Green
title	done

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

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.

Note: n cannot be higher than 50000.

Page properties

hidden	true

Short description

Adds or subtracts natural days (or working days) to or from any given date.

Output

Status

subtle	true
title	number

Available since

Status

subtle	true
colour	Blue
title	2.2.7

Label

Status

colour	Red
title	staff pick

Parameter explanation....

Output

asdsadasdas

Info

Content

Space Tools

Versions Compared

Old Version 26

New Version Current

Key

Parameters used in this function

Parameters used in this function

Image AddedUse cases and examples