Page History

Versions Compared

Old Version 4

changes.mady.by.user Iheb Kharab

Saved on Mar 17, 2020

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on Oct 19, 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 description

Adds timeToBeAdded to t and returns a

Status

subtle	true
title	number

Output

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

This function adds timeToBeAdded to t and returns a

Status

subtle	true
title	number

with the difference that weekends do not count in the sum.

UI Text Box

type	tip

or subtracts time to or from any given date.

Weekends will not be counted as working daysUse negative values at timeToBeAdded for subtracting time from t.

Code Block

language	bash
title	Syntax
linenumbers	true

addTimeSkippingWeekends(number ttimestamp, number timeToBeAdded, timeZone time_zone) #Output: Number

UI Expand

title	Examples

Parser expression	Description

UI Text Box

type	info

t represents a date-time which coincides with a Saturday

timeToBeAdded = 2 * {HOUR}

The function will return a date-time for next Monday at 02:00

Code Block

language	bash
linenumbers	true

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.

Code Block

language	bash
linenumbers	true

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.

Code Block

language	bash
linenumbers	true

addTimeSkippingWeekends({issue.dueDate}, - 1 * {YEAR}, LOCAL)

This example subtracts 1 year from the issue's due date.

Weekends won't be taken into account.

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

numberOfDaystimeToBeAdded

Status

subtle	true
title	number

The number defined here will be the offset in days.

The offset, supporting the usage of time macros. Learn more about time macros. 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.subtract time.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

Expand

title	Learn more about timezones

Excerpt Include

Dates, times and time zones Dates, times and time zones

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.

mediuminfo

UI Expand

title	Output

The This function returns a

Status

subtle	true
title	number

with the difference that weekends do not count in the sum representing a timestamp.

UI Text Box

size

type

tip

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.

UI Text Box

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). function returns a

Status

subtle	true
title	number

with a custom defined weekend.
beginning_of_weekend and end_of_weekend take the following values : {MONDAY} , {TUESDAY} ... {SUNDAY}.

Code Block

language	bash
title	Syntax
linenumbers	true

addTimeSkippingWeekends(number ttimestamp, number timeToBeAdded, timeZone time_zone, number beginning_of_weekendstartOfWeekend, number end_of_weekendendOfWeekend) #Output: Number

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

addTimeSkippingWeekends({

system.currentDateTime}, 12 * {HOUR}, LOCAL, {FRIDAY}, {SATURDAY})

The function

This example adds 12 hours to

the current local time, and taking into consideration a weekend that begins with a Friday and ends with a Saturday

the current date and time.

Fridays and Saturdays are not counted and will be skipped.

Code Block

language	bash
linenumbers	true

addTimeSkippingWeekends({system.currentDateTime}, -2 * {DAY}, LOCAL, {SUNDAY}, {TUESDAY})

This example subtracts 2 days from the current date and time.

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

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

numberOfDaystimeToBeAdded

Status

subtle	true
title	number

The number defined here will be the offset in days. The offset, supporting the usage of time macros. Learn more about time macros.

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 subtract time.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

expand

startOfWeekend

Status

title
subtle	true

Learn more about timezones

Excerpt Include

Dates, times and time zones Dates, times and time zones

nopanel true

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

The This function returns a

Status

subtle	true
title	number

with a custom defined weekend.

representing a timestamp

UI Text Box

type	tip

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.

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

Page properties

hidden	true

Short description

Adds or subtracts time to or from any given date.

Output

Status

subtle	true
title	number

Available since

Status

subtle	true
colour	Blue
title	2.2.7

Label

Content

Space Tools

Versions Compared

Old Version 4

New Version Current

Key

Image AddedUse cases and examples