Versions Compared

Old Version 2

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

Saved on

compared with

New Version 3

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 DATETIME


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


Syntax

Code Block
dateTime + number period



Inputs

  • 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
Back to top



_nav_BackToTop


Panel
bgColorwhite

SUBTRACT PERIOD FROM DATE


This function calculates a new date by subtracting a specified period from a specified date.


Syntax

Code Block
date - number period



Inputs
  • date - The date that you want to subtract the specified period from.
  • number - Specifies how many periods you want to subtract from the date.
  • period - A keyword that specifies which time unit to subtract. Valid units are DAYS, WEEKS, MONTHS and YEARS.


Return type

  • date


Examples

ExpressionResultType
01-01-2015 – 1 DAYS31-12-2014Date
01-01-2015 – 1 WEEKS25-12-2014Date
01-01-2015 – 1 MONTHS01-12-2014Date
01-01-2015 – 1 YEARS01-01-2014Date
Include Page
_nav_BackToTop
Back to top



Panel
bgColorwhite

SUBTRACT PERIOD FROM DATETIME


This function calculates a new dateTime by subtracting a specified period from a specified dateTime.


Syntax

Code Block
dateTime - number period



Inputs
  • dateTime - The dateTime that you want to subtract the specified period from.
  • number - Specifies how many periods you want to subtract from the dateTime.
  • period - A keyword that specifies which time unit to subtract. Valid units are DAYS, WEEKS, MONTHS, YEARS, HOURS, MINUTES and SECONDS.


Return type

  • dateTime


Examples

ExpressionResultType
01-01-2015 13:23:04 – 1 HOURS01-01-2015 12:23:04DateTime
01-01-2015 13:23:04 – 25 HOURS

31-12-2014 12:23:04

DateTime
01-01-2015 13:23:04 – 60 SECONDS01-01-2015 13:22:04DateTime
01-01-2015 13:23:04 – 1 MINUTES01-01-2015 13:22:04DateTime
Include Page
_nav_BackToTop_nav_BackToTop
Back to top