Skip to main content

 

Planview Customer Success Center

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))