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.
Duration(hopIdOrName, utcStartDateTime, utcEndDateTime, units)
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|
|Quick Actions (except UI Quick Actions)||Yes|
|UI Quick Actions||No|
|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.
|hopIdOrName||The hours of operation schedule name as defined.|
The start date and time in DateTime value.
The end date and time in DateTime value.
The units (example: SECONDS, MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS).
$(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