Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')),)
month(FINANCIAL_DATE)
this is not what i want .. i want june to dec months for 2016 and jan to june months for 2017 ...
exact condition
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?