getWorkingInterval

getWorkingInterval

We've encountered an issue exporting this macro. Please try exporting again later.

Syntax

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

Package

Alias

Pkg Usage

Description

Returns the number of working hours from a time interval.

Parameters

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

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

Need support? Create a request with our support team.

Copyright © 2005 - 2026 Appfire | All rights reserved.