Hitachi Vantara Pentaho Community Wiki

Versions Compared

Key

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

 Provides an internal number for the given date Construct date from year, month, and day of month.

Syntax

Code Block

YEAR (year ; month ; day)

Syntax: DATE( Integer Year ; Integer Month ; Integer Day )
Returns: Date
Constraints: 1 <= Month <= 12; 1 <= Day <= 31

Semantics: This computes the date's serial number given Year, Month, and Day. Fractional values are truncated.

year (required) - An integer between 1583 and 9956, or 0 - 99representing the year.
month (required) - An integer between 1 and 12 representing month.
day (required) - An integer between 1 and 31 representing day of month. 

Examples

Syntax

Result

report: =DATE(1969 ; 6 ; 21)

June 21, 1969

report: =DATE(1 ; 6 ; 21 )

June 21, 2001 1 AD

BYear = 1969
BMonth = 6
BDay = 21
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="40e52d2989c48c2b-67ee31ca-41ac4ef9-8efab886-c3eb9cdcbcb6f1abe3716545"><ac:plain-text-body><![CDATA[report: =DATE([BYear];[BMonth];[BDay])

June 21, 1969

]]></ac:plain-text-body></ac:structured-macro>