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 shows how many returns the number of working days passed from issue creation date until it was resolved (resolution day is not included).
DateDiffWorkdays([Issue].get('Created at'),
[Issue].get('Resolved at'))The same example that returns difference in working days from Issue created date until resolution if non-working days are Friday and Saturday:
DateDiffWorkdays([Issue].get('Created at'), [Issue].get('Resolved at'), '56'in the current month (days from Monday to Friday)
(DateDiffWorkdays( [Time].CurrentMember.StartDate, [Time].CurrentMember.NextStartDate,'67'))
See also