topic Re: Convert text to Date in QlikView https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129747#M19558 <HTML><HEAD></HEAD><BODY><P>May be try</P><P></P><P>Month(Date#(Trim(Subfield('01 - January', '-', 1)) ,'M') )</P><P>--------</P><P>Month(Date#(Trim(Subfield(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">MONTH_REF </SPAN>, '-', 1)) ,'M') )</P></BODY></HTML> Fri, 14 Sep 2018 17:57:19 GMT vamsee 2018-09-14T17:57:19Z Convert text to Date https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129746#M19557 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have the field MONTH_REF with value "01 - Januery", how i can convert this for month?</P><P></P><P></P><P>All help will be appreciated</P></BODY></HTML> Fri, 14 Sep 2018 17:39:53 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129746#M19557 breno_morais 2018-09-14T17:39:53Z Re: Convert text to Date https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129747#M19558 <HTML><HEAD></HEAD><BODY><P>May be try</P><P></P><P>Month(Date#(Trim(Subfield('01 - January', '-', 1)) ,'M') )</P><P>--------</P><P>Month(Date#(Trim(Subfield(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">MONTH_REF </SPAN>, '-', 1)) ,'M') )</P></BODY></HTML> Fri, 14 Sep 2018 17:57:19 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129747#M19558 vamsee 2018-09-14T17:57:19Z Re: Convert text to Date https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129748#M19559 <HTML><HEAD></HEAD><BODY><P>try this -</P><P>Date(Date#(Left(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">MONTH_REF</SPAN>,2), 'MM'), 'MMM')</P></BODY></HTML> Fri, 14 Sep 2018 17:59:35 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129748#M19559 neelamsaroha157 2018-09-14T17:59:35Z Re: Convert text to Date https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129749#M19560 <HTML><HEAD></HEAD><BODY><P>Exactly what I need. thank you</P></BODY></HTML> Fri, 14 Sep 2018 18:05:51 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-Date/m-p/129749#M19560 breno_morais 2018-09-14T18:05:51Z