SUBTRACT PERIOD FROM DATE
Calculates a new date by subtracting a specified period from a specified date.
Syntax
date - number period |
Inputs
- date - The date that you want to subtract the specified period from.
- number - Specifies how many periods you want to subtract from the date.
- period - A keyword that specifies which time unit to subtract. Valid units are DAYS, WEEKS, MONTHS and YEARS.
Return type
- date
Examples
| Expression | Result | Type |
|---|---|---|
| 01-01-2015 – 1 DAYS | 31-12-2014 | Date |
| 01-01-2015 – 1 WEEKS | 25-12-2014 | Date |
| 01-01-2015 – 1 MONTHS | 01-12-2014 | Date |
| 01-01-2015 – 1 YEARS | 01-01-2014 | Date |