Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColorwhite

ADD PERIOD TO DATE


This function calculates Calculates a new date by adding a specified period to a specified date.


Syntax

Code Block
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.
Info
UI Text Box
typenote

If you prefer a functional syntax, you can use the INCREMENT_period functions. For example: INCREMENT_DAYS( 0102-01-2015 , 1 ) = 02-01-2015


Return type

  • date


Examples

ExpressionAlternative syntaxResultType
DATE("2015-01-01
-2015
") + 1 DAYSINCREMENT_DAYS( DATE("2015-01-01
-2015
")  , 1 )
02
2015-01-
2015
02Date
DATE("2015-01-01
-2015
") + 1 WEEKSINCREMENT_WEEKS( DATE("2015-01-01
-2015
")  , 1 )
08
2015-01-
2015
08Date
DATE("2015-01-01
-2015
") + 1 MONTHSINCREMENT_MONTHS( DATE("2015-01-01
-2015
")  , 1 )
01
2015-02-
2015
01Date
DATE("2015-01-01
-2015
") + 1 YEARSINCREMENT_YEARS( DATE("2015-01-01
-2015
")  , 1 )

2016-01-01

-2016

Date


Back to top