Allows for the increase or decrease of a date/time by a set interval.
- DateAddValue("IntervalString", ValueToAdd, DateToEffect)
IntervalString - represents the interval, must be enclosed in double-quotes and can be:
- d - Day
- h - Hour
- n - Minute
- m - Month
- q - Quarter
- s - Second
- ww - Week
- yyyy - Year
Example: DateAddValue("d",-4,{close_date})
Input: 12/30/2010
Result: 12/26/2010
Example: DateAddValue("m",3,{close_date})
Input: 12/30/2010
Result: 3/30/2011
Click HERE to return to the full list of MassImpact Formulas
