topic Date- to select month in QlikView https://community.qlik.com/t5/QlikView/Date-to-select-month/m-p/468576#M1163819 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>how do i select month&nbsp; for a date.</P><P>example: </P><P>date : 30 jan 2012, 4 feb 2012</P><P></P><P>how do i extract only jan and feb and turn the data into 01 for jan, and 02 for feb</P><P></P><P>tq</P></BODY></HTML> Tue, 27 Nov 2012 03:04:36 GMT 2012-11-27T03:04:36Z Date- to select month https://community.qlik.com/t5/QlikView/Date-to-select-month/m-p/468576#M1163819 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>how do i select month&nbsp; for a date.</P><P>example: </P><P>date : 30 jan 2012, 4 feb 2012</P><P></P><P>how do i extract only jan and feb and turn the data into 01 for jan, and 02 for feb</P><P></P><P>tq</P></BODY></HTML> Tue, 27 Nov 2012 03:04:36 GMT https://community.qlik.com/t5/QlikView/Date-to-select-month/m-p/468576#M1163819 2012-11-27T03:04:36Z Re: Date- to select month https://community.qlik.com/t5/QlikView/Date-to-select-month/m-p/468577#M1163820 <HTML><HEAD></HEAD><BODY><P>You can use the Month() function to extract the month from a proper date.</P><P></P><P>If it's not working, it means that your dates are not properly recognized as dates and you need to define for QlikView the format. For example:</P><P></P><P><EM>Month(Date#(DATEFIELD, 'DD MMM YYYY')) as Month</EM></P></BODY></HTML> Tue, 27 Nov 2012 03:21:05 GMT https://community.qlik.com/t5/QlikView/Date-to-select-month/m-p/468577#M1163820 Anonymous 2012-11-27T03:21:05Z