Skip to end of metadata
Go to start of metadata

Cprime Apps has been rebranded as Anova Apps. Please note the only effect is the company name - all of our products’ names, logos, functionalities, support, etc. is exactly the same. The new location to our documentation space is


This routine is available starting with SIL Engine™ 2.5.


getWorkingInterval(startDate, endDate, startWorkingHour, endWorkingHour, weekendDays, holidays)


Returns the number of working hours from a time interval.


startDateDateYesStart working date.
endDateDateYesEnd working date.
startWorkingHourStringYesDaily start working hour (HH:mm).
endWorkingHourStringYesDaily end working hour (HH:mm).
weekendDaysNumber arrayYesWeekend days (day of week).
holidaysDate arrayYesDates of the free days.

Return type


The returned number represents the working hours from the given time interval.


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