DATE - NUMBER (of) DAYS (- Operator)
The DATE - DAYS operator calculates a new date value by subtracting the number of days from a DATE you specify.
The DATE - DAYS operator works with a date value, which can be a date expression, a Date variable, or the result of a function that returns a date. The number of days to be subtracted can be a number value, which can be a number expression, a Number variable, or the result of a function that returns a number.
Operator | Description | After you drag and drop the operator into the script tab: | Expression returns: |
DATE - NUMBER (of) DAYS | ⟦Date⟧ - ⟦Number⟧ DAYS | Replace ⟦DATE⟧ placeholder with the date value you want to subtract from. Replace ⟦Number⟧ placeholder with the number value you want to subtract. | A DATE value. |
Example
DATE OF(31, 12, 2020) - 3 DAYS // Results in the date value 12/28/2020