You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Returns a 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.

Syntax
subtractDatesSkippingWeekends(number minuend_date, number subtrahend_date, timeZone time_zone) #Output: Number
Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.

timeZone

TIMEZONE

The time zone used for the calculation. 

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. 

Output

The function returns a NUMBER


Similar to the previous function, but with a custom defined weekend.

Arguments beginning_of_weekend and end_of_weekend take values {MONDAY}, {TUESDAY} ... {SUNDAY} .

Syntax
subtractDatesSkippingWeekends(number minuend_date, number subtrahend_date, timeZone time_zone, number beginning_of_weekend, number end_of_weekend) #Output: number
Examples
Parser expression Description
subtractDatesSkippingWeekends({00112}, {00009}, LOCAL, {FRIDAY}, {SATURDAY})

Calculating the worktime from Creating to Resolution using Israeli weekend.

{00112} is field code for Resolution date and time

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

Additional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.

timeZone

TIMEZONE

The time zone used for the calculation. 

<parameter>

DATA TYPE

Parameter description.
<parameter>

DATA TYPE

Parameter description.

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. 

Output

The function returns a NUMBER