topic Monthend with YYYYMM input in QlikView https://community.qlik.com/t5/QlikView/Monthend-with-YYYYMM-input/m-p/199099#M58166 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I'm trying to use the Monthend() function with YYYYMM input. I don't really if it's something possible, as this function expect a complete Date format. Have you any ideas ?</P><P></P><P>Thanks for your help,</P><P>Jaymerry</P></BODY></HTML> Thu, 03 Feb 2011 11:05:14 GMT jaymerry 2011-02-03T11:05:14Z Monthend with YYYYMM input https://community.qlik.com/t5/QlikView/Monthend-with-YYYYMM-input/m-p/199099#M58166 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I'm trying to use the Monthend() function with YYYYMM input. I don't really if it's something possible, as this function expect a complete Date format. Have you any ideas ?</P><P></P><P>Thanks for your help,</P><P>Jaymerry</P></BODY></HTML> Thu, 03 Feb 2011 11:05:14 GMT https://community.qlik.com/t5/QlikView/Monthend-with-YYYYMM-input/m-p/199099#M58166 jaymerry 2011-02-03T11:05:14Z Monthend with YYYYMM input https://community.qlik.com/t5/QlikView/Monthend-with-YYYYMM-input/m-p/199100#M58167 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>The following should work:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=MonthEnd(Date(Date#('201101', 'YYYYMM')))</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Thu, 03 Feb 2011 11:07:34 GMT https://community.qlik.com/t5/QlikView/Monthend-with-YYYYMM-input/m-p/199100#M58167 Miguel_Angel_Baeyens 2011-02-03T11:07:34Z Monthend with YYYYMM input https://community.qlik.com/t5/QlikView/Monthend-with-YYYYMM-input/m-p/199101#M58168 <HTML><HEAD></HEAD><BODY><P>Thank you very much,</P><P>It works,</P><P>Jaymerry</P></BODY></HTML> Thu, 03 Feb 2011 12:02:09 GMT https://community.qlik.com/t5/QlikView/Monthend-with-YYYYMM-input/m-p/199101#M58168 jaymerry 2011-02-03T12:02:09Z