topic Convert Month to Date in QlikView https://community.qlik.com/t5/QlikView/Convert-Month-to-Date/m-p/306109#M113025 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My excel source I only have Month Name which is Jan, Feb, Mar and so on.&nbsp; Please advise what is the script for converting to Date.&nbsp;&nbsp; </P></BODY></HTML> Fri, 16 Dec 2011 00:56:37 GMT 2011-12-16T00:56:37Z Convert Month to Date https://community.qlik.com/t5/QlikView/Convert-Month-to-Date/m-p/306109#M113025 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My excel source I only have Month Name which is Jan, Feb, Mar and so on.&nbsp; Please advise what is the script for converting to Date.&nbsp;&nbsp; </P></BODY></HTML> Fri, 16 Dec 2011 00:56:37 GMT https://community.qlik.com/t5/QlikView/Convert-Month-to-Date/m-p/306109#M113025 2011-12-16T00:56:37Z Re: Convert Month to Date https://community.qlik.com/t5/QlikView/Convert-Month-to-Date/m-p/306110#M113026 <HTML><HEAD></HEAD><BODY><P>How do you know the year?&nbsp; Is it always the current year?&nbsp; How about the day?&nbsp; First of the month?&nbsp; Plenty of ways to do it.&nbsp; Here are a couple:</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">makedate(year(today()),month(date#(MonthName,'MMM')),1)</SPAN><BR /><SPAN style="font-family: courier new,courier;">date(date#(year(today()) &amp; MonthName,'YYYYMMM'))</SPAN></P></BODY></HTML> Fri, 16 Dec 2011 01:19:21 GMT https://community.qlik.com/t5/QlikView/Convert-Month-to-Date/m-p/306110#M113026 johnw 2011-12-16T01:19:21Z