Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

 Provides an internal number for the given date.

Syntax

YEAR (year ; month ; day)

year (required) - An integer between 1583 and 9956, or 0 - 99.

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

BYear = 1969
BMonth = 6
BDay = 21
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="da8d87f0-7f96-45d2-801d-f330e6b1a063"><ac:plain-text-body><![CDATA[report: DATE([BYear];[BMonth];[BDay])

June 21, 1969

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

  • No labels