Skip to main content
Skip table of contents

DateDiffWorkdays

Returns number of working days (by default excluding Saturday and Sunday) from first date to second date.

Syntax

CODE
DateDiffWorkdays(from_date, to_date)
DateDiffWorkdays(from_date, to_date, nonworkdays)

Arguments

from_date

MDX expression that returns a date. Starting date that, if it is workday, will be included in calculation.

to_date

MDX expression that returns a date. Date until which to count workdays; this day itself will not be included in calculation even if it is workday.

nonworkdays

Specify string with non-working day numbers (use 1 for Monday, 2 for Tuesday, 3 for Wednesday, 4 for Thursday, 5 for Friday, 6 for Saturday, 7 for Sunday).

If not specified then '67' is used which means Saturday and Sunday.

Examples

Following example returns the number of working days in the current month (days from Monday to Friday)

CODE
(DateDiffWorkdays(
  [Time].CurrentMember.StartDate,
  [Time].CurrentMember.NextStartDate,
'67'))
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.