Views:

Description

Returns the next working time given a date to start from and a number of minutes to increment by.

Uses a Monday - Friday work week by default and the records defined in the business close calendar within CRM.

Signature

GetNextWorkingTime(
  'startdate',
  'useBusinessCalendar',
  'DayStartTime', 
  'DayEndTime',
  'NumberOfMins'
)

Example

GetNextWorkingTime(
  '12/20/2012 16:00:00',
  true,
  '9:30',
  '17:00',
  90
)
Returns 12/21/2012 10:00:00 (US Format)

Parameters

Name Type Description Required
startdate xxxx xxxx xxxx
useBusinessCalendar xxxx xxxx xxxx
DayStartTime xxxx xxxx xxxx
DayEndTime xxxx xxxx xxxx
NumberOfMins xxxx xxxx xxxx