Hitachi Vantara Pentaho Community Wiki

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

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

Syntax

Code Block
YEAR( 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"
 
report: YEAR([BDate])

1969