topic Re: Getting Date from text in QlikView https://community.qlik.com/t5/QlikView/Getting-Date-from-text/m-p/584184#M1100452 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">Date(Date#(DateField, '</SPAN><SPAN style="font-size: 14.399999618530273px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f6f6f6;">MMM D, YYYY</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">')) as DateField</SPAN></P></BODY></HTML> Wed, 16 Apr 2014 09:21:39 GMT MK_QSL 2014-04-16T09:21:39Z Getting Date from text https://community.qlik.com/t5/QlikView/Getting-Date-from-text/m-p/584183#M1100451 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>How can I get date from text in format 'MMM D, YYYY'?</P><P>For instance:</P><P>Apr 1, 2014</P><P>Apr 12, 2014</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 16 Apr 2014 08:59:54 GMT https://community.qlik.com/t5/QlikView/Getting-Date-from-text/m-p/584183#M1100451 yura_ratu 2014-04-16T08:59:54Z Re: Getting Date from text https://community.qlik.com/t5/QlikView/Getting-Date-from-text/m-p/584184#M1100452 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">Date(Date#(DateField, '</SPAN><SPAN style="font-size: 14.399999618530273px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f6f6f6;">MMM D, YYYY</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">')) as DateField</SPAN></P></BODY></HTML> Wed, 16 Apr 2014 09:21:39 GMT https://community.qlik.com/t5/QlikView/Getting-Date-from-text/m-p/584184#M1100452 MK_QSL 2014-04-16T09:21:39Z Re: Getting Date from text https://community.qlik.com/t5/QlikView/Getting-Date-from-text/m-p/584185#M1100453 <HTML><HEAD></HEAD><BODY><P>Copy of <A _jive_internal="true" href="https://community.qlik.com/thread/114596">http://community.qlik.com/thread/114596</A></P><P></P><P>Correct answer is marked in that thread.</P></BODY></HTML> Wed, 16 Apr 2014 09:55:25 GMT https://community.qlik.com/t5/QlikView/Getting-Date-from-text/m-p/584185#M1100453 ThornOfCrowns 2014-04-16T09:55:25Z