topic Re: Convert string to Date formate in QlikView https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146485#M375131 <HTML><HEAD></HEAD><BODY><P>What is the output you want to get from April_2016-2017?</P></BODY></HTML> Tue, 26 Jul 2016 12:19:15 GMT sunny_talwar 2016-07-26T12:19:15Z Convert string to Date formate https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146484#M375130 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a string format with April_2016-2017</P><P></P><P>need to convert to different formats </P><P>i,e 2016-2017 </P><P>April</P><P>2016</P><P>2017</P><P></P><P></P><P>Thank you</P></BODY></HTML> Tue, 26 Jul 2016 11:59:33 GMT https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146484#M375130 vamsi_krishna 2016-07-26T11:59:33Z Re: Convert string to Date formate https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146485#M375131 <HTML><HEAD></HEAD><BODY><P>What is the output you want to get from April_2016-2017?</P></BODY></HTML> Tue, 26 Jul 2016 12:19:15 GMT https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146485#M375131 sunny_talwar 2016-07-26T12:19:15Z Re: Convert string to Date formate https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146486#M375132 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">i need 3 different formats</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2016-2017</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">April</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2016</P></BODY></HTML> Tue, 26 Jul 2016 12:21:03 GMT https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146486#M375132 vamsi_krishna 2016-07-26T12:21:03Z Re: Convert string to Date formate https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146487#M375133 <HTML><HEAD></HEAD><BODY><P>did u try this?</P><P>dat:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; F1</P><P>&nbsp;&nbsp;&nbsp; April_2016-2017</P><P>];</P><P></P><P></P><P>LOAD *,</P><P></P><P></P><P>subfield(F1, '_' ,1) as 1,</P><P>subfield(F1, '_' ,2) as 2,</P><P>SubField(F1,'-',3) as 3</P><P>Resident dat;</P></BODY></HTML> Tue, 26 Jul 2016 12:23:20 GMT https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146487#M375133 Chanty4u 2016-07-26T12:23:20Z Re: Convert string to Date formate https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146488#M375134 <HTML><HEAD></HEAD><BODY><P>no its not working</P></BODY></HTML> Tue, 26 Jul 2016 12:32:36 GMT https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146488#M375134 vamsi_krishna 2016-07-26T12:32:36Z Re: Convert string to Date formate https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146489#M375135 <HTML><HEAD></HEAD><BODY><P>May be</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> <SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #800000;">Field</SPAN>,'_'),'-') <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">Field</SPAN><BR /> <SPAN style="color: #0000ff;">INLINE</SPAN> <SPAN style="color: #800000;">[<BR /> Field<BR /> April_2016-2017<BR /> ]</SPAN></SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132472_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Tue, 26 Jul 2016 12:34:11 GMT https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146489#M375135 antoniotiman 2016-07-26T12:34:11Z Re: Convert string to Date formate https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146490#M375136 <HTML><HEAD></HEAD><BODY><P>Perhaps this is what you seek:</P><P></P><P></P><P>data:</P><P>LOAD * INLINE [</P><P>&nbsp; field</P><P>&nbsp; April_2016-2017</P><P>];</P><P></P><P>test:</P><P>LOAD </P><P>&nbsp; *,</P><P>&nbsp; subfield(field, '_' ,2)&nbsp; as YearRange,</P><P>&nbsp; subfield(field, '_' ,1)&nbsp; as Month,</P><P>&nbsp; subfield(subfield(field, '_' ,2), '-', 1)&nbsp; as FirstYear</P><P>Resident data;</P></BODY></HTML> Tue, 26 Jul 2016 16:27:37 GMT https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146490#M375136 Anonymous 2016-07-26T16:27:37Z Re: Convert string to Date formate https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146491#M375137 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> <SPAN style="color: #0000ff;">DISTINCT</SPAN> <SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #800000;">Field</SPAN>,'_'),'-')&amp;'|'&amp;<SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #800000;">Field</SPAN>,'_',-1),'|') <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">Field</SPAN><BR /> <SPAN style="color: #0000ff;">INLINE</SPAN> <SPAN style="color: #800000;">[<BR /> Field<BR /> April_2016-2017<BR /> ]</SPAN></SPAN><SPAN style="font-size: 10pt;">;&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132511_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Tue, 26 Jul 2016 17:21:46 GMT https://community.qlik.com/t5/QlikView/Convert-string-to-Date-formate/m-p/1146491#M375137 antoniotiman 2016-07-26T17:21:46Z