Page Comparison

Info

title	Availability

This routine is available starting with SIL Engine™ 2.5.

Button handy

blank	true
color	#0052CC
name	Send Feedback
link	https://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=getWorkingInterval+-+15483941
width	auto

Table plus

applyColStyleToCell	true
heading	0
columnTypes	s,s,s,s
multiple	false
columnAttributes	style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,
enableSorting	false

Syntax	getWorkingInterval(startDate, endDate, startWorkingHour, endWorkingHour, weekendDays, holidays)	Package
Alias		Pkg Usage

Description

Excerpt

hidden	true

Returns the number of working hours from a time interval.

Parameters

Table plus

applyColStyleToCell	true
columnTypes	s,s,s,s
heading	0
multiple	false
enableSorting	false

Parameter name	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

numberNumber

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

Example

Code Block

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

Versions Compared

Old Version 1

New Version Current

Key

Description

Parameters

Return

Type

Example

See also