Versions Compared

Old Version 1

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

Saved on

compared with

New Version 2

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

Saved on

Key

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


_nav_BackToTop

Panel
bgColorwhite

ADD PERIOD TO DATE


This function 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
Include Page
_nav_BackToTop
Back to top

Panel
bgColorwhite

ADD PERIOD TO DATETIME

This function calculates a new dateTime by adding a specified period to a specified dateTime.

Syntax

Code Block
dateTime + number period
  • dateTime - The dateTime that you want to add the specified period to.
  • number - Specifies how may periods you want to add to the dateTime.
  • period - A keyword that specifies which time unit to add. Valid units are DAYS, WEEKS, MONTHS, YEARS, HOURS, MINUTES and SECONDS.

Return type

  • dateTime

Examples

ExpressionResultType
01-01-2015 13:23:04 + 1 DAYS02-01-2015 13:23:04DateTime
01-01-2015 13:23:04 + 25 HOURS02-01-2015 14:23:04DateTime
01-01-2015 13:23:04 + 60 SECONDS01-01-2015 13:24:04DateTime
01-01-2015 13:23:04 + 1 MINUTES01-01-2015 13:24:04DateTime


Include Page
_nav_BackToTop
_nav_BackToTop

...