Skip to main content

 

Planview Customer Success Center

DateAdd Function

DateAdd (dateTime as DateTime, duration as Duration) as DateTime

Category: Date
Description: Adds a duration value to a date and returns date
Supported Context: FormulaField And BusinessRules
Parameters:  
dateTime as DateTime Represents the original date as a date or reference to a field that will return a date value
duration as Duration Represents a duration or reference to a field that will return a duration value (i.e. 4d or 20h)
Returned value as DateTime Returns a date value equal to the "dateTime" parameter plus the "duration" parameter
Example #1

Create a Date Custom Field that will forecast the realistic due date of a work item, based on another duration custom field called Buffer, that will include both the original due date of the work item as well as the defined buffer. Set the formula to be:

DateAdd($DueDate,$Buffer)

Tips
  • To update standard date/date time fields, use workflow rules
  • Review other useful date and duration functions such as DateSubstract(), ToDate(), etc.
Related Functions

DateSubtract()

ToDate()