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

Version 1 Next »

Returns the year of a date, an integer between 1583 and 9956.

Syntax

MONTH( date )

date
format: month/day/year or  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: YEAR("6/21/69")

1969

report: YEAR("1969-6-21")

1969

BDate = "6/21/69"
 
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="62bbf92b-48a4-4cc9-9e65-af36e3efba60"><ac:plain-text-body><![CDATA[report: YEAR([BDate])

1969

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

  • No labels