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 |
|
Related Functions |