GetWorkingTimeForGivenPeriod Function
GetWorkingTimeForGivenPeriod (user as ObjectIdentifier, dateTime1 as DateTime, dateTime2 as DateTime) as Duration
Category: | Date |
Description: | Returns the Working Time for a user for a specific period of time. Where the "user" argument can be a specific user or a reference to user field. "dateTime1" and "dateTime2" arguments are used to determine the period of interest. |
Supported Context: | FormulaField And BusinessRules |
Parameters: | |
user as ObjectIdentifier(User) | Represents a reference to a user object or a field that returns a user object |
dateTime1 as DateTime | Represents a reference to a from date or field that returns a date value |
dateTime2 as DateTime | Represents a reference to a to date or field that returns a date value |
Returned value as Duration | Returns a duration value equal to the total number of working hours for the user specified in the "user" parameter for the date range specified in the "dateTime1" and "dateTime2" parameters |
Example #1 |
Calculate the Bill to Burn KPI on the user entity. Within a workflow rule, select the "Update Field" action and select the custom field Bill to Burn KPI (needs to be created by your organization first). $C_BilltoBurn/(GetWorkingTimeForGivenPeriod(CurrentUser(), 06/05/2011, 07/15/2011)/Hours(1)) |