Skip to main content

 

Planview Customer Success Center

Weeks Function

Weeks (number as Numeric, isWorking as Boolean) as Duration

Category: Date
Description: Returns duration value in weeks. If IsWorking (optional parameter, default is FALSE) set to TRUE returns only the working duration.
Supported Context: FormulaField And BusinessRules
Parameters:  
number as Numeric Numeric value or reference to a numeric field
isWorking as Boolean An optional parameter that allows you to return only work days or calendar days. Enter a value of "TRUE" for working weeks, or "FALSE" for total calendar weeks
Returned value as Duration Returns a duration value in weeks based on the "number" parameter entered either as working weeks or calendar weeks as determined in the "isWorking" parameter
Example #1

Build a date custom field for an issue that will define the maximum tolerated response date, which, in this case, is 2 working weeks for a critical bug and 4 working weeks for other other severity levels

If($severity= "critical", $CreatedOn + weeks(2,TRUE), $CreatedOn+weeks(4,TRUE))

Example #2 DateAdd
Example #3 ToDate
Tips
  • To update standard date/date time fields, use workflow rules
  • Review other date and duration useful functions, such as DateAdd(), ToDate(), etc
Additional Links

checkbox custom field