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.

Syntax

Code Block
YEAR (year ; month ; day)

...

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="011749c4361952d6-b0e1cffe-4def4664-ab2e9909-c68fe41694c9ce1aefe46f51"><ac:plain-text-body><![CDATA[report: DATE([BYear];[BMonth];[BDay])

June 21, 1969

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