Availability
This routine is available starting with katl-commons 2.5.
Syntax
getWorkingInterval(startDate, endDate, startWorkingHour, endWorkingHour, weekendDays, holidays)
Description
Returns the number of working hours from a time interval.
Parameters
Parameter | Type | Required | Description |
---|---|---|---|
startDate | Date | Yes | the start working date |
endDate | Date | Yes | the end working date |
startWorkingHour | String | Yes | the daily start working hour (HH:mm) |
endWorkingHour | String | Yes | the daily end working hour (HH:mm) |
weekendDays | Number array | Yes | the weekend days (day of week) |
holidays | Date array | Yes | the dates of the free days |
Return type
number
The returned number represents the working hours from the given time interval.
Example
number hours; date startDate = "2012-01-10 12:00:00"; date endDate = "2012-01-20 10:30:00"; string startHour = "09:00"; string endHour = "17:00"; number[] weekend = {7, 1}; date[] holidays = {"2012-01-18", "2012-01-16"}; hours = getWorkingInterval(startDate, endDate, startHour, endHour, weekend, holidays);
Returns the number of working hours from 2012-01-10 12:00 to 2012-01-20 10:30, excluding the weekends (7 is Saturday and 1 is Sunday) and holidays (2012-01-18 and 2012-01-16).
See also