topic Converting string to month in QlikView https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234134#M85603 <HTML><HEAD></HEAD><BODY><P>You need to use Date# function</P><P>In your example it should be date#(MyField,'MMM-YY')</P><P>Rgds,</P><P>Sébastien</P></BODY></HTML> Tue, 28 Dec 2010 14:06:10 GMT 2010-12-28T14:06:10Z Converting string to month https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234133#M85602 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Is it possible to convert the string into Month. I have a column with string values like Jan-10,Feb-10.... I am trying to sort it in the original order as Jan,Feb ... in the bar chart. Since it is string the same can be done by converting the values to date format. Is there any other way to acheive this without changing the database level(Since huge data is there).</P></BODY></HTML> Tue, 28 Dec 2010 13:56:48 GMT https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234133#M85602 2010-12-28T13:56:48Z Converting string to month https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234134#M85603 <HTML><HEAD></HEAD><BODY><P>You need to use Date# function</P><P>In your example it should be date#(MyField,'MMM-YY')</P><P>Rgds,</P><P>Sébastien</P></BODY></HTML> Tue, 28 Dec 2010 14:06:10 GMT https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234134#M85603 2010-12-28T14:06:10Z Converting string to month https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234135#M85604 <HTML><HEAD></HEAD><BODY><P>Thanks Sebastien,</P><P>It is working fine as expected.</P></BODY></HTML> Tue, 28 Dec 2010 14:25:43 GMT https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234135#M85604 2010-12-28T14:25:43Z Converting string to month https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234136#M85605 <HTML><HEAD></HEAD><BODY><P>Great !</P><P></P></BODY></HTML> Tue, 28 Dec 2010 14:50:13 GMT https://community.qlik.com/t5/QlikView/Converting-string-to-month/m-p/234136#M85605 2010-12-28T14:50:13Z