Versions Compared

Old Version 6

changes.mady.by.user Unknown User (a.jansen)

Saved on

compared with

New Version 7

changes.mady.by.user Unknown User (a.jansen)

Saved on

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

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

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

01-01-2016

Date


Back to top