Skip to main content

 

  • arrow icon
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Weeks Function

  1. Last updated
  2. Save as PDF

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