Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0811

D toc

Excerpt

Calculates the number of working days between two specified dates, assuming Monday - Friday workweek. Optional list of holidays can be specified.

  • Inputs can be column references or the outputs of the DATE or TIME functions.
  • The first value is used as the baseline to compare the date values.
  • If the first date value occurs after the second date value, a null value is returned.

D s lang vs sql

D s
snippetBasic

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:datedif(StartDate, EndDate, month)

networkdays(StartDate, EndDate)

Output: Returns the number of working days between StartDate and EndDate.

D s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:datedif(date1,date2,date_units)

networkdays(date1,date2,[array_holiday])


ArgumentRequired?Data TypeDescription
date1YdatetimeStarting date to compare
date2YdatetimeEnding date to compare
array_holidayNarrayAn array of string values representing the valid dates of holidays.

D s lang notes

date1, date2

Date values can be column references or output of the DATE function or the TIME function.

Date values to compared in working days.

  • If date2 > date1, then results are positive.
  • If date2 < date1, then a null value is returned.

If date1 and date2 have a specified time zone offset, the function calculates the difference including the timezone offsets.

  • If date1 does not have a specified time zone but date2 does, the function uses the local time in the same time zone as date2 to calculate the difference. The functions returns the difference without the time zone offset.

D s
snippetusage

Required?Data TypeExample Value
YesDatetime (Column reference or date output of DATE or TIME function)LastContactDate

array_holiday

An array containing the list of holidays, which are factored in the calculation of working days.

Values in the array must be in either of the following formats:

Code Block
['2020-12-24','2020-12-25']
['2020/12/24','2020/12/25']


D s
snippetusage

Required?Data TypeExample Value
YesArray['2018-12,24','2018-12-25','2018-12-31','2019-01-01']

D s
snippetExamples

Example - Date diffing functions

Include Page
EXAMPLE - Date Difference Functions
EXAMPLE - Date Difference Functions

D s also
labeldate