Support center for flex.bi version 4.0
DateDiffWorkdays
Returns number of working days (by default excluding Saturday and Sunday) from first date to second date.
Syntax
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 |
Examples
Following example returns the number of working days in the current month (days from Monday to Friday)
(DateDiffWorkdays( [Time].CurrentMember.StartDate, [Time].CurrentMember.NextStartDate,'67'))
See also