topic Re: Month function in expressions in QlikView https://community.qlik.com/t5/QlikView/Month-function-in-expressions/m-p/1067288#M1294584 <HTML><HEAD></HEAD><BODY><P>Use the date#() function instead of the date() function.</P></BODY></HTML> Mon, 11 Jan 2016 21:41:17 GMT oknotsen 2016-01-11T21:41:17Z Month function in expressions https://community.qlik.com/t5/QlikView/Month-function-in-expressions/m-p/1067287#M1294583 <HTML><HEAD></HEAD><BODY><P>Hi, I have date filed as </P><P></P><P>1/29/2014</P><P>3/22/2014</P><P>7/15/2014</P><P>5/23/2014</P><P>12/24/2014</P><P></P><P>I am trying to extract Month in a list box expressions, But I am not getting as needed</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> Month(Date(Apld_Dt, 'DD/MM/YYYY')) </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Month (Apld_Dt)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">As a result I am getting as x -<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Please advise</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Month-function-in-expressions/m-p/1067287#M1294583 2026-01-26T18:19:17Z Re: Month function in expressions https://community.qlik.com/t5/QlikView/Month-function-in-expressions/m-p/1067288#M1294584 <HTML><HEAD></HEAD><BODY><P>Use the date#() function instead of the date() function.</P></BODY></HTML> Mon, 11 Jan 2016 21:41:17 GMT https://community.qlik.com/t5/QlikView/Month-function-in-expressions/m-p/1067288#M1294584 oknotsen 2016-01-11T21:41:17Z Re: Month function in expressions https://community.qlik.com/t5/QlikView/Month-function-in-expressions/m-p/1067289#M1294585 <HTML><HEAD></HEAD><BODY><P>Yup like <A _jive_internal="true" href="https://community.qlik.com/people/okg">Onno van Knotsenburg</A>‌ said, may be you need to tell QlikView that this is a date. And you can do that using Date#() function:</P><P></P><P><STRONG>Month(Date#(ApId_Dt, 'M/D/YYYY')) as Month</STRONG></P></BODY></HTML> Mon, 11 Jan 2016 21:49:01 GMT https://community.qlik.com/t5/QlikView/Month-function-in-expressions/m-p/1067289#M1294585 sunny_talwar 2016-01-11T21:49:01Z