Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8? Click here and leave these dusty old pages behind!
Availability
This routine is available starting with SIL Engine™ 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 | Start working date. |
endDate | Date | Yes | End working date. |
startWorkingHour | String | Yes | Daily start working hour (HH:mm). |
endWorkingHour | String | Yes | Daily end working hour (HH:mm). |
weekendDays | Number array | Yes | Weekend days (day of week). |
holidays | Date array | Yes | 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