topic Create Date in QlikView https://community.qlik.com/t5/QlikView/Create-Date/m-p/860605#M1005595 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have a Month field containing values Jan to Dec.</P><P>How can I create a dummy date field using the Month field I already have?</P></BODY></HTML> Thu, 14 May 2015 11:23:15 GMT 2015-05-14T11:23:15Z Create Date https://community.qlik.com/t5/QlikView/Create-Date/m-p/860605#M1005595 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have a Month field containing values Jan to Dec.</P><P>How can I create a dummy date field using the Month field I already have?</P></BODY></HTML> Thu, 14 May 2015 11:23:15 GMT https://community.qlik.com/t5/QlikView/Create-Date/m-p/860605#M1005595 2015-05-14T11:23:15Z Re: Create Date https://community.qlik.com/t5/QlikView/Create-Date/m-p/860606#M1005596 <HTML><HEAD></HEAD><BODY><P>This should work:</P><P>=date(date#(2015 &amp; "MonthField" &amp; 01, 'YYYYMMMDD'))</P></BODY></HTML> Thu, 14 May 2015 11:27:26 GMT https://community.qlik.com/t5/QlikView/Create-Date/m-p/860606#M1005596 Anonymous 2015-05-14T11:27:26Z Re: Create Date https://community.qlik.com/t5/QlikView/Create-Date/m-p/860607#M1005597 <HTML><HEAD></HEAD><BODY><P>Could you attach the sample data.</P></BODY></HTML> Thu, 14 May 2015 11:31:27 GMT https://community.qlik.com/t5/QlikView/Create-Date/m-p/860607#M1005597 satishqlik 2015-05-14T11:31:27Z Re: Create Date https://community.qlik.com/t5/QlikView/Create-Date/m-p/860608#M1005598 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use makeDate()</P><P></P><P>makeDate(2015,MonthField,1)</P><P></P><P>Regards</P></BODY></HTML> Thu, 14 May 2015 11:35:00 GMT https://community.qlik.com/t5/QlikView/Create-Date/m-p/860608#M1005598 PrashantSangle 2015-05-14T11:35:00Z Re: Create Date https://community.qlik.com/t5/QlikView/Create-Date/m-p/860609#M1005599 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Like this:</P></BODY></HTML> Thu, 14 May 2015 11:36:54 GMT https://community.qlik.com/t5/QlikView/Create-Date/m-p/860609#M1005599 amit_saini 2015-05-14T11:36:54Z Re: Create Date https://community.qlik.com/t5/QlikView/Create-Date/m-p/860610#M1005600 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!</P></BODY></HTML> Thu, 14 May 2015 11:40:50 GMT https://community.qlik.com/t5/QlikView/Create-Date/m-p/860610#M1005600 2015-05-14T11:40:50Z Re: Create Date https://community.qlik.com/t5/QlikView/Create-Date/m-p/860611#M1005601 <HTML><HEAD></HEAD><BODY><P>MakeDate(num(financialyear),num(wildmatch([month],'Jan*','Feb*','Mar*','Apr*','May*','Jun*','Jul*','Aug*','Sep*','Oct*','Nov*','Dec*')),1)</P><P></P><P>Try the above logic...</P></BODY></HTML> Thu, 14 May 2015 11:42:25 GMT https://community.qlik.com/t5/QlikView/Create-Date/m-p/860611#M1005601 mohammadkhatimi 2015-05-14T11:42:25Z