Returns the number of working hours from the first date to the second date.

Syntax

DateDiffWorkhours(from_date, to_date, nonworkdays, businesshours)
CODE

Arguments

from_date

MDX expression that returns a date. Starting date, if it is a workday, will be included in the 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 a workday.

nonworkdays

Specify a 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, and 7 for Sunday).

businesshours

Specify a string with business hours (start and end) in 24-h clock time or 12-h clock time.

Examples

The following example returns a difference in workhours from the Issue created date until resolution if non-working days are Friday and Saturday and working hours are defined from 9 am to 5 pm (incl). That means if the event happened at 5:59 pm it would still be included.

DateDiffWorkhours([Issue].get('Created at'),
    [Issue].get('Resolved at'), '56', '9-17')
CODE

See also

  • Function DateDiffDays which returns the number of days between two dates.

  • Function DateDiffWorkdays which returns the number of workdays between two dates.