MONTH( )
Returns the month for a specified date value.
Syntax
MONTH(date)
MONTH(date, option)
Arguments
date
The date or date expression whose month to get.
option
A number that represents the month format to return. Use one of the following values:
*
*
*
If you omit option, MONTH( ) returns the month as a number.
Returns
The month for a specified date value.
Example
The following example returns the month (1 – 12) for each value in the ShipDate data field:
MONTH([ShipDate])
The following example returns the full month name for each ShipDate value:
MONTH([ShipDate], 2)

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2