topic Converting date to month year in QlikView https://community.qlik.com/t5/QlikView/Converting-date-to-month-year/m-p/313349#M1198205 <HTML><HEAD></HEAD><BODY><P>I have a list of dates which i have converted to month and year for use in selections within an application. </P><P><STRONG>year(date)</STRONG>, <STRONG>month(date) </STRONG>etc. </P><P></P><P>I was wondering if it was possible to create a combined date/month field for use in selections.</P><P></P><P>I have tried to convert it using <STRONG>(Date(Date, 'MMM-YY')) as MonthYear</STRONG>, but when creating a list box it has created a MonthYear for every date in that month.</P><P></P><P>Thanks for any help</P></BODY></HTML> Thu, 19 May 2011 14:32:38 GMT 2011-05-19T14:32:38Z Converting date to month year https://community.qlik.com/t5/QlikView/Converting-date-to-month-year/m-p/313349#M1198205 <HTML><HEAD></HEAD><BODY><P>I have a list of dates which i have converted to month and year for use in selections within an application. </P><P><STRONG>year(date)</STRONG>, <STRONG>month(date) </STRONG>etc. </P><P></P><P>I was wondering if it was possible to create a combined date/month field for use in selections.</P><P></P><P>I have tried to convert it using <STRONG>(Date(Date, 'MMM-YY')) as MonthYear</STRONG>, but when creating a list box it has created a MonthYear for every date in that month.</P><P></P><P>Thanks for any help</P></BODY></HTML> Thu, 19 May 2011 14:32:38 GMT https://community.qlik.com/t5/QlikView/Converting-date-to-month-year/m-p/313349#M1198205 2011-05-19T14:32:38Z Converting date to month year https://community.qlik.com/t5/QlikView/Converting-date-to-month-year/m-p/313350#M1198206 <HTML><HEAD></HEAD><BODY><P>Use this:</P><P> (Date(monthstart(Date), 'MMM-YY'))</P></BODY></HTML> Thu, 19 May 2011 14:42:12 GMT https://community.qlik.com/t5/QlikView/Converting-date-to-month-year/m-p/313350#M1198206 erichshiino 2011-05-19T14:42:12Z Re: Converting date to month year https://community.qlik.com/t5/QlikView/Converting-date-to-month-year/m-p/1653714#M1198207 <P>u saved me thanks</P> Tue, 03 Dec 2019 18:10:39 GMT https://community.qlik.com/t5/QlikView/Converting-date-to-month-year/m-p/1653714#M1198207 havko 2019-12-03T18:10:39Z