get month from date field

[capriconuser]

i want to extract months for  2016 (July-Dec)

and 2017 ( Jan-June)

from date how should i do this ?

Match(Year(Month(FINANCIAL_DATE,'DD-MMM-YYYY')),)

[mtucholski]

month(FINANCIAL_DATE)

[capriconuser]

this is not what i want .. i want june to dec months for 2016 and jan to june months for 2017 ...

exact condition

[mtucholski]

You have a data, where you want to extract months from dates, but only from dates from 2016-06 to 2017-06 ignoring other dates. Or do you want to make a calendar from 2016-06 to 2017-06. Please be more specific. How about a data sample?