Page History

Versions Compared

Key

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

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

Subtracts two timestamps ignoring the weekends.

Output

Status

subtle	true
title	number

Available since

Status

subtle	true
colour	Blue
title	2.2.7

UI Text Box

size	medium
type	info

This functions subtracts two timestamps (the second date will be substracted from the first date) ignoring the weekends.

This way you can easily calculate the elapsed working time since weekends will be ignored.

Code Block

language	bash
title	Syntax
linenumbers	true

subtractDatesSkippingWeekends(firstDate, dateToSubstract, timeZone) #Output: Number

UI Expand

title	Examples

Parser expression

Description

Code Block

linenumbers	true

subtractDatesSkippingWeekends({issue.resolutionDate}, {issue.created}, LOCAL)

This example calculates the elapsed working time from issue creation to resolution

The result will return milliseconds.

Code Block

linenumbers	true

round(subtractDatesSkippingWeekends(({issue.resolutionDate}, {issue.created}, LOCAL)/{HOUR})

This example returns the hours instead of milliseconds.

Additional useful functions can be found here: Numbers

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

firstDate

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

dateToSubstract

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

timeZone

Status


subtle	true
title	timezone

The time zone used for the conversion.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

representing a timestamp.

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

Code Block

language	bash
title	Syntax
linenumbers	true

subtractDatesSkippingWeekends(firstDate, dateToSubtract, timeZone, startOfWeekend, endOfWeekend) #Output: number

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

subtractDatesSkippingWeekends({issue.resolutionDate}, {issue.created}, LOCAL, {FRIDAY}, {SATURDAY})

This example calculates the elapsed working time from issue creation to resolution using an Arabic weekend.

The result will return milliseconds.

Code Block

language	bash
linenumbers	true

round(subtractDatesSkippingWeekends({issue.resolutionDate}, {issue.created}, LOCAL, {FRIDAY}, {SATURDAY})/{DAY})

This example returns the full days instead of milliseconds.

To achieve this the {DAY} time macro and the round()function are used.

Additional useful functions can be found here: Numbers

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

firstDate

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

dateToSubtract

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

timeZone

Status


subtle	true
title	timezone

The time zone used for the conversion.

startOfWeekend

Status

subtle	true
title	number

The parameter will take values in the format of {MONDAY},{TUESDAY}...{SUNDAY}

endOfWeekend

Status

subtle	true
title	number

The parameter will take values in the format of {MONDAY},{TUESDAY}...{SUNDAY}

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 number field.

Another very common use case is to use this function in a JWT calculated date-time fields. If you don't want to work with milliseconds check out all available time macros.

If you want to simply add days to a timestamp you might want to have a look at the function addDaysSkippingWeekends().

Not sure what this function returns? Simply test your expression on the expression parser test page.

Content

Space Tools

Versions Compared

Old Version 13

New Version 14

Key