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

Returns a

Status

subtle	true
title	number

representing a timestamp equivalent "minuend_date - subtrahend_date" subtracting weekend periods from the resultSubtracts two timestamps ignoring the weekends.

Output

Status

subtle	true
title	number

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

Status

subtle	true
title	number

representing a timestamp equivalent "minuend_date - subtrahend_date" subtracting weekend periods from the result. i.e., you get the elapsed working time from subtrahend_date to minuend_date.

Code Block

language	bash
title	Syntax
linenumbers	true

subtractDatesSkippingWeekends(number minuend_datefirstDate, number subtrahend_datedateToSubstract, timeZone time_zone) #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})

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

<parameter>firstDate

Status


subtle	true
title	data type

Parameter description.

number

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

dateToSubstract<parameter>

Status


subtle	true
title	data type	number

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

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculationconversion.

true

ui-expand

title	Output

The function returns a

Status

subtle	true
title	number

representing a timestamp.

Learn more about timezones

Excerpt Include

Dates, times and time zones

nopanel

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

Status

subtle	true
title	number

ui-text-box

size	medium
type	info

Similar to Variantof the previous function, but with a custom defined weekend.Arguments beginning_of_weekend and end_of_weekend take values {MONDAY}, {TUESDAY} ... {SUNDAY} .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(number minuend_datefirstDate, number subtrahend_datedateToSubtract, 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

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

Calculating the worktime from Creating to Resolution using Israeli weekend.

UI Text Box

type	note

{00112} is field code for Resolution date and time.

{00009} is field code for Creation date and time.

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.

Additional useful functions can be found here: Numbers and mathematical functions

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

<parameter>firstDate

Status


subtle	true
title	data type

Parameter description.

number

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

dateToSubtract<parameter>

Status


subtle	true
title	data type	number

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

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculationconversion.

startOfWeekend

Status

expand

title	Learn more about timezones

Excerpt Include

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

nopanel true

subtle	true
title	number

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

endOfWeekend<parameter>

Status

title
subtle	true

data type

Parameter description.

number

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

Parameter description

UI Expand

title	Output

The function returns a

Status

title
subtle	true

data type

number

representing a timestamp.

number

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

Status

subtle

true

title

Content

Space Tools

Versions Compared

Old Version 6

New Version 7

Key

Parameters used in this function

Parameters used in this function