topic Convert Month Name to a Date in QlikView https://community.qlik.com/t5/QlikView/Convert-Month-Name-to-a-Date/m-p/1056786#M919126 <HTML><HEAD></HEAD><BODY><P>I'm sure that this really easy, but if I'm given a month name such as "February" in an excel file and need to convert it to a Date value such as 'MM/DD/YYYY', how would I do that? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT brf10043 2020-11-25T16:16:04Z Convert Month Name to a Date https://community.qlik.com/t5/QlikView/Convert-Month-Name-to-a-Date/m-p/1056786#M919126 <HTML><HEAD></HEAD><BODY><P>I'm sure that this really easy, but if I'm given a month name such as "February" in an excel file and need to convert it to a Date value such as 'MM/DD/YYYY', how would I do that? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-Month-Name-to-a-Date/m-p/1056786#M919126 brf10043 2020-11-25T16:16:04Z Re: Convert Month Name to a Date https://community.qlik.com/t5/QlikView/Convert-Month-Name-to-a-Date/m-p/1056787#M919127 <HTML><HEAD></HEAD><BODY><P>I just worked this out.&nbsp; I discovered Date# </P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Mon, 02 May 2016 15:43:23 GMT https://community.qlik.com/t5/QlikView/Convert-Month-Name-to-a-Date/m-p/1056787#M919127 brf10043 2016-05-02T15:43:23Z Re: Convert Month Name to a Date https://community.qlik.com/t5/QlikView/Convert-Month-Name-to-a-Date/m-p/1056788#M919128 <HTML><HEAD></HEAD><BODY><P>is it just February or is it an entire date like Feb 03 2016</P><P></P><P>=date(date#('Feb 03 2016', 'MMM DD YYYY'), 'MM/DD/YYYY')</P></BODY></HTML> Mon, 02 May 2016 15:47:33 GMT https://community.qlik.com/t5/QlikView/Convert-Month-Name-to-a-Date/m-p/1056788#M919128 2016-05-02T15:47:33Z