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

Returns the month of a date, 1 through 12.

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: MONTH("6/21/69")

6

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

6

BDate = "6/21/69"
 
report: MONTH([BDate])

6


  • No labels

1 Comment


  1. Rajkumar , From TECHLAB , Bhubaneswar

    Soory To Say this , This is giving a invalid Result . MONTH() function returns a value from 1-12 but here it returning  a invalid value ,