You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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

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

  • No labels