Versions Compared

Old Version 5

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

Saved on

compared with

New Version 6

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


Back to top