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.
Panel
bgColorwhite

DATE


You can use this function to create a date value out of integers or numbers.


UI Text Box
typenote

Numbers will be rounded to integers.

UI Text Box
typenote
There is also a conversion function DATE.


Syntax

Code Block
 DATE ( year , month , day )

Inputs
  • year - An integer value between and including 1 and 9999 that represents the year in the constructed date.
  • month - An integer value between and including 1 and 12 that represents the month in the constructed date.
  • day - An integer value between and including 1 and 31 that represents the day in the constructed date.


Return type

  • date


Examples

ExpressionResultType
DATE ( 2010 , 5 , 25 )25-5-2010Date
DATE ( -2010 , 5 , 25 )UNKNOWNDate
DATE ( 2010 , 2 , 29 )Error
Include Page
_nav_BackToTop


_nav_BackToTop

Back to top

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
  • 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
_nav_BackToTop

...