Versions Compared

Key

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


Page properties
hiddentrue



Status
Tech review

Status
titletodo

Style guide

Status
titletodo

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged



Page properties
hiddentrue


Short description

Returns a 

Status
subtletrue
titlenumber
representing a timestamp equivalent "minuend_date - subtrahend_date" subtracting weekend periods from the result.

Output

Status
subtletrue
titlenumber




UI Text Box
sizemedium
typeinfo

Returns a 

Status
subtletrue
titlenumber
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
languagebash
titleSyntax
linenumberstrue
subtractDatesSkippingWeekends(number minuend_date, number subtrahend_date, timeZone time_zone) #Output: Number


UI Expand
titleExamples



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
<parameter>

Status
subtletrue
titledata type

Parameter description.
<parameter>

Status
subtletrue
titledata type

Parameter description.

timeZone

Status
subtletrue
titletimezone

The time zone used for the calculation. 

Expand
titleLearn more about timezones

Excerpt Include
Dates, times and time zones
Dates, times and time zones
nopaneltrue



ui-text-box
typetip

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
titleOutput

The function returns a

Status
subtletrue
titlenumber