Page History

Versions Compared

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

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

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

Code Block

title	Syntax
linenumbers	true

addDaysSkippingWeekends(timestamp, numberOfDays, timeZone)

UI Expand

title	Examples

Parser expression

Description

Code Block

linenumbers	true

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

This function adds 2 days to the

Status

subtle	true
title	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.

Code Block

linenumbers	true

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

This function substracts 2 days to the

Status

subtle	true
title	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.

Code Block

linenumbers	true

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

This function substracts 6 days from the

Status

subtle	true
title	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.

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

Status


subtle	true
title	timezone

The time zone used for the calculation.

Expand

title	Learn more about timezones

Excerpt Include

	Dates, times and timezones
	Dates, times and timezones
nopanel	true

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 a JWT calculated date-time field.

UI Text Box

size	medium
type	info

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)

Code Block

title	Syntax
linenumbers	true

addDaysSkippingWeekends(timestamp, numberOfDays, timeZone, startOfWeekend, endOfWeekend)

UI Expand

title	Examples

Parser expression

Description

Code Block

linenumbers	true

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

This function adds 2 days to the

Status

subtle	true
title	Timestamp

Code Block

linenumbers	true

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

This function substracts 2 days to the

Status

subtle	true
title	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.

Code Block

linenumbers	true

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

This function substracts 6 days from the

Status

subtle	true
title	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.

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

Status


subtle	true
title	timezone

The time zone used for the calculation.

Expand

title	Learn more about timezones

Excerpt Include

	Dates, times and timezones
	Dates, times and timezones
nopanel	true

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 a JWT calculated date-time field.

Content

Space Tools

Versions Compared

Old Version 37

New Version 38

Key

Parameters used in this function

Parameters used in this function