Duration

Calculates the duration, in seconds, between two dates and times based on an hours of operations (HOP) schedule. The hours of operation calculation is based on the hours of operation schedule, which is set in the application configuration.

Syntax

Duration(hopIdOrName, utcStartDateTime, utcEndDateTime, units)

Enabled For

For a description of the business object categories, see Notes on "Enabled For".

Business Object Category	Yes/No
Business Rules: Before-Save Rules	Yes
Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load)	Yes1
Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load)	Yes
Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load)	Yes1
Business Rules: Editing Rules	Yes2
Business Rules: Initialization Rules	Yes
Business Rules: Read Only Rules	No
Business Rules: Required Rules	Yes2
Business Rules: Validation Rules	Yes
Client Expressions	No
Object Permissions	No
Services	No
LDAP	No
Mobile	No
Quick Actions (except UI Quick Actions)	Yes
UI Quick Actions	No
Reports	Yes
Search/Dashboard without field references	No
Search/Dashboard with field references	No
1. Not fully supported in calculation rules that have a condition of After Save or have the Also Recalculate on Load option selected. It may fail if the rule's field is used in a grid, form, or saved search. 2. Except when this field appears on a form or is triggered by such a field.

Parameters

Parameter	Description
hopIdOrName	The hours of operation schedule name as defined.
utcStartDateTime	The start date and time in DateTime value.
utcEndDateTime	The end date and time in DateTime value.
units	The units (example: SECONDS, MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS).

Return Value

Number value

Example

$(Duration("24 x 7", "1/1/2022 10:45:00 AM", "5/30/2022 10:45:00 PM", "DAYS"))

Returns this value: 149.5 days