topic Re: get month from date field in App Development https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97790#M6529 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Wed, 18 Jul 2018 06:53:07 GMT mtucholski 2018-07-18T06:53:07Z get month from date field https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97787#M6526 <HTML><HEAD></HEAD><BODY><P>i want to extract months for&nbsp; 2016 (July-Dec)</P><P>and 2017 ( Jan-June)</P><P>from date how should i do this ?</P><P></P><P>Match(Year(Month(FINANCIAL_DATE,'DD-MMM-YYYY')),)</P></BODY></HTML> Wed, 18 Jul 2018 05:37:10 GMT https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97787#M6526 capriconuser 2018-07-18T05:37:10Z Re: get month from date field https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97788#M6527 <HTML><HEAD></HEAD><BODY><P>month(FINANCIAL_DATE)</P></BODY></HTML> Wed, 18 Jul 2018 05:44:42 GMT https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97788#M6527 mtucholski 2018-07-18T05:44:42Z Re: get month from date field https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97789#M6528 <HTML><HEAD></HEAD><BODY><P>this is not what i want .. i want june to dec months for 2016 and jan to june months for 2017 ... </P><P></P><P></P><P>exact condition </P></BODY></HTML> Wed, 18 Jul 2018 06:07:43 GMT https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97789#M6528 capriconuser 2018-07-18T06:07:43Z Re: get month from date field https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97790#M6529 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Wed, 18 Jul 2018 06:53:07 GMT https://community.qlik.com/t5/App-Development/get-month-from-date-field/m-p/97790#M6529 mtucholski 2018-07-18T06:53:07Z