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 https://anovaapps.atlassian.net.
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.
|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.|
The returned number represents the working hours from the given time interval.
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).