Description
Returns the working time between two dates. So you could calculate the number of business hours between two dates.
Uses a Monday - Friday work week by default and the records defined in the business close calendar within CRM.
Signature
GetDifferenceWorkingTime( 'startdate', 'enddate' 'usebusinesscalendar', 'daystarttime', 'dayendtime', 'interval' )
Example
GetDifferenceWorkingTime( '12/20/2012 10:00:00', '12/20/2012 13:00:00', true, '9:00', '19:00', 'h') Returns 3 (US Format)
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| key | xxxx | xxxx | xxxx |
| defaultvalue | xxxx | xxxx | xxxx |