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 field:
MONTH([ShipDate])
The following example returns the full month name for each ShipDate value:
MONTH([ShipDate], 2)

Additional Links:

Copyright Actuate Corporation 2012