topic Re: Date in text format with Long Month Name in QlikView https://community.qlik.com/t5/QlikView/Date-in-text-format-with-Long-Month-Name/m-p/464032#M1155734 <HTML><HEAD></HEAD><BODY><P>date#(MyDateField,'YYYY MMMM 28') + 27 as MyDateField</P><P></P><P>date#('2012 September 28','YYYY MMMM 28') is 41153 so add 27 to get 41180</P><P></P><P>Just kidding, but you get the idea I hope.</P></BODY></HTML> Fri, 22 Feb 2013 17:07:54 GMT Gysbert_Wassenaar 2013-02-22T17:07:54Z Date in text format with Long Month Name https://community.qlik.com/t5/QlikView/Date-in-text-format-with-Long-Month-Name/m-p/464031#M1155733 <HTML><HEAD></HEAD><BODY><P>I am trying to load an excel file with dates in following text format: 2012 September 28.</P><P></P><P>How can I convert this to date number 41180?</P></BODY></HTML> Fri, 22 Feb 2013 17:01:35 GMT https://community.qlik.com/t5/QlikView/Date-in-text-format-with-Long-Month-Name/m-p/464031#M1155733 mazacini 2013-02-22T17:01:35Z Re: Date in text format with Long Month Name https://community.qlik.com/t5/QlikView/Date-in-text-format-with-Long-Month-Name/m-p/464032#M1155734 <HTML><HEAD></HEAD><BODY><P>date#(MyDateField,'YYYY MMMM 28') + 27 as MyDateField</P><P></P><P>date#('2012 September 28','YYYY MMMM 28') is 41153 so add 27 to get 41180</P><P></P><P>Just kidding, but you get the idea I hope.</P></BODY></HTML> Fri, 22 Feb 2013 17:07:54 GMT https://community.qlik.com/t5/QlikView/Date-in-text-format-with-Long-Month-Name/m-p/464032#M1155734 Gysbert_Wassenaar 2013-02-22T17:07:54Z Re: Date in text format with Long Month Name https://community.qlik.com/t5/QlikView/Date-in-text-format-with-Long-Month-Name/m-p/464033#M1155735 <HTML><HEAD></HEAD><BODY><P>Thank you Gysbert.</P><P></P><P>I have a number of different dates. So I changed your suggestion slightly to:</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>Date# <SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">,'YYYY MMMM DD') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN></P><P></P><P></P><P></P><P>Works great!</P></BODY></HTML> Fri, 22 Feb 2013 17:16:39 GMT https://community.qlik.com/t5/QlikView/Date-in-text-format-with-Long-Month-Name/m-p/464033#M1155735 mazacini 2013-02-22T17:16:39Z