topic Convert text to date in QlikView https://community.qlik.com/t5/QlikView/Convert-text-to-date/m-p/671882#M1078043 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 210px;"><TBODY><TR><TD class="xl63" height="17" width="210">Miércoles 22 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Jueves 23 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Viernes 24 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Sábado 25 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Domingo 26 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Lunes 27 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Martes 28 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Miércoles 29 de Mayo del 2013</TD></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><P>I don´t&nbsp; know how to Covert: TEXT ----&gt; (Miércoles 22 de Mayo del 2013)&nbsp; to this format -----&gt; ('DD/MM/YYYY')=(22/05/2013)</P><P>in qlikview.</P><P></P><P>Can somebody help me please !!!</P><P></P><P>Thanks!!!</P></BODY></HTML> Mon, 14 Jul 2014 18:11:04 GMT Anonymous 2014-07-14T18:11:04Z Convert text to date https://community.qlik.com/t5/QlikView/Convert-text-to-date/m-p/671882#M1078043 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 210px;"><TBODY><TR><TD class="xl63" height="17" width="210">Miércoles 22 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Jueves 23 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Viernes 24 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Sábado 25 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Domingo 26 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Lunes 27 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Martes 28 de Mayo del 2013</TD></TR><TR><TD class="xl63" height="17">Miércoles 29 de Mayo del 2013</TD></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="73"></TABLE><P>I don´t&nbsp; know how to Covert: TEXT ----&gt; (Miércoles 22 de Mayo del 2013)&nbsp; to this format -----&gt; ('DD/MM/YYYY')=(22/05/2013)</P><P>in qlikview.</P><P></P><P>Can somebody help me please !!!</P><P></P><P>Thanks!!!</P></BODY></HTML> Mon, 14 Jul 2014 18:11:04 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-date/m-p/671882#M1078043 Anonymous 2014-07-14T18:11:04Z Re: Convert text to date https://community.qlik.com/t5/QlikView/Convert-text-to-date/m-p/671883#M1078044 <HTML><HEAD></HEAD><BODY><P>Holà Carlos,</P><P></P><P>You can achieve this using the following approach:</P><P></P><P><STRONG style="color: #0000ff;">SET</STRONG> <STRONG><EM style="color: #999999;">LongMonthNames</EM></STRONG>='Enero;Febrero;Marzo;Abril;Mayo;Junio;Julio;Agosto;Septiembre;Octubre;Noviembre;Diciembre';</P><P></P><P>spanish_dates:</P><P><STRONG style="color: #0000ff;">LOAD</STRONG> * <SPAN style="color: #0000ff;">inline</SPAN> <SPAN style="color: #800000;">[</SPAN></P><P><SPAN style="color: #800000;">Sdate</SPAN></P><P><SPAN style="color: #800000;">Miércoles 22 de Mayo del 2013</SPAN></P><P><SPAN style="color: #800000;">Jueves 23 de Mayo del 2013</SPAN></P><P><SPAN style="color: #800000;">Viernes 24 de Mayo del 2013</SPAN></P><P><SPAN style="color: #800000;">Sábado 25 de Mayo del 2013</SPAN></P><P><SPAN style="color: #800000;">Domingo 26 de Mayo del 2013</SPAN></P><P><SPAN style="color: #800000;">Lunes 27 de Mayo del 2013</SPAN></P><P><SPAN style="color: #800000;">Martes 28 de Mayo del 2013</SPAN></P><P><SPAN style="color: #800000;">Miércoles 29 de Mayo del 2013]</SPAN>;</P><P></P><P>qlikview_dates:</P><P><STRONG style="color: #0000ff;">LOAD</STRONG> <SPAN style="color: #800000;">Sdate</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">[Spanish Long Date]</SPAN></P><P>&nbsp;&nbsp; , <SPAN style="color: #0000ff;">Date</SPAN>(<SPAN style="color: #0000ff;">Date#</SPAN>(<SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #800000;">Sdate</SPAN>, ' ', 2) &amp; ' ' &amp; <SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #800000;">Sdate</SPAN>, ' ', 4) &amp; ' ' &amp; <SPAN style="color: #0000ff;">SubField</SPAN>(<SPAN style="color: #800000;">Sdate</SPAN>, ' ', 6), 'DD MMMM YYYY')) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">[QlikView Date]</SPAN></P><P><SPAN style="color: #0000ff;">Resident</SPAN> spanish_dates;</P><P></P><P><STRONG style="color: #0000ff;">DROP</STRONG> <SPAN style="color: #0000ff;">Table</SPAN> spanish_dates;</P><P></P><P>Please find attached the example QVW file, regards,</P><P></P><P>Philippe</P></BODY></HTML> Mon, 14 Jul 2014 18:34:07 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-date/m-p/671883#M1078044 pgrenier 2014-07-14T18:34:07Z Re: Convert text to date https://community.qlik.com/t5/QlikView/Convert-text-to-date/m-p/671884#M1078045 <HTML><HEAD></HEAD><BODY><P>Thanks for the support Philippe! </P></BODY></HTML> Mon, 14 Jul 2014 19:09:26 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-date/m-p/671884#M1078045 Anonymous 2014-07-14T19:09:26Z