isWorkDay

isWorkDay evaluates a given date-time value to determine if the value is a workday or not.

isWorkDay assumes a standard five-day work week starting on Monday and ending on Friday. Saturday and Sunday are assumed to be weekends. The function always calculates its result at the DAY granularity and is exclusive of the given input date.

Syntax

Copy 
isWorkDay(inputDate)

Arguments

inputDate

The date-time value that you want to evaluate. Valid values are as follows:

  • Dataset fields: Any date field from the dataset that you are adding this function to.
  • Date Functions: Any date output from another date function, for example, parseDate.
  • Calculated fields: Any Insights calculated field that returns a date value.
  • Parameters: Any Insights DateTime parameter.

Return type

Integer (0 or 1)

Example

The following example determines whether or not the application_date field is a work day.

Let's assume that there's a field named application_date with the following values:

Copy 
2022-08-10 
2022-08-06 
2022-08-07

When you use these fields and add the following calculations, isWorkDay returns the below values:

Copy 
isWorkDay({application_date})     
                                                     
1
0
0

The following example filters employees whose employment ends on a work day and determines whether their employment began on work day or a weekend using conditional formatting:

Copy 
is_start_date_work_day = isWorkDay(employment_start_date)
is_end_date_work_day = isWorkDay(employment_end_date)