FISCAL_MONTH

Returns a number representing the fiscal month of "date_expression". This differs from CALENDAR_MONTH() if your organization uses a fiscal year that does not match the Gregorian calendar. If your fiscal year starts in March, 1 for March 12 for February.

Syntax

FISCAL_MONTH ( date_expression )

Example

FISCAL_MONTH ( '2012-02-29' )

Result