getWorkingInterval

Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8 for Server/Data Center? Click here !

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).