Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

get month from date field

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')),)

3 Replies
mtucholski
Creator
Creator

month(FINANCIAL_DATE)

capriconuser
Creator
Creator
Author

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

exact condition

mtucholski
Creator
Creator

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?