ADD PERIOD TO DATE
Calculates a new date by adding a specified period to a specified date.
Syntax
date + number period |
Inputs
- date - The date that you want to add the specified period to.
- number - Specifies how may periods you want to add to the date.
- period - A keyword that specifies which time unit to add. Valid units are DAYS, WEEKS, MONTHS and YEARS.
If you prefer a functional syntax, you can use the INCREMENT_period functions. For example: INCREMENT_DAYS( 01-01-2015 , 1 ) = 02-01-2015 |
Return type
- date
Examples
| Expression | Alternative syntax | Result | Type |
|---|---|---|---|
| 01-01-2015 + 1 DAYS | INCREMENT_DAYS( 01-01-2015 , 1 ) | 02-01-2015 | Date |
| 01-01-2015 + 1 WEEKS | INCREMENT_WEEKS( 01-01-2015 , 1 ) | 08-01-2015 | Date |
| 01-01-2015 + 1 MONTHS | INCREMENT_MONTHS( 01-01-2015 , 1 ) | 01-02-2015 | Date |
| 01-01-2015 + 1 YEARS | INCREMENT_YEARS( 01-01-2015 , 1 ) | 01-01-2016 | Date |