topic Make date in QlikView https://community.qlik.com/t5/QlikView/Make-date/m-p/543053#M1127996 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have Year and Month</P><P><STRONG>Year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month</STRONG></P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P></P><P>How to make date ............</P></BODY></HTML> Sat, 07 Dec 2013 17:50:40 GMT paulwalker 2013-12-07T17:50:40Z Make date https://community.qlik.com/t5/QlikView/Make-date/m-p/543053#M1127996 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have Year and Month</P><P><STRONG>Year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month</STRONG></P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P></P><P>How to make date ............</P></BODY></HTML> Sat, 07 Dec 2013 17:50:40 GMT https://community.qlik.com/t5/QlikView/Make-date/m-p/543053#M1127996 paulwalker 2013-12-07T17:50:40Z Re: Make date https://community.qlik.com/t5/QlikView/Make-date/m-p/543054#M1127998 <HTML><HEAD></HEAD><BODY><P><STRONG>Paul</STRONG></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; date(date#(<EM>[Year]</EM> &amp; num( <EM>[Month]</EM> ,'00'),'YYYYMM'))</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Sat, 07 Dec 2013 18:29:34 GMT https://community.qlik.com/t5/QlikView/Make-date/m-p/543054#M1127998 Anonymous 2013-12-07T18:29:34Z Re: Make date https://community.qlik.com/t5/QlikView/Make-date/m-p/543055#M1128000 <HTML><HEAD></HEAD><BODY><P>Please try with <STRONG>MakeDate</STRONG> function like below:</P><P></P><P><STRONG>MakeDate(Year,Month) AS DATE_FIELD</STRONG></P></BODY></HTML> Sat, 07 Dec 2013 20:52:43 GMT https://community.qlik.com/t5/QlikView/Make-date/m-p/543055#M1128000 2013-12-07T20:52:43Z Re: Make date https://community.qlik.com/t5/QlikView/Make-date/m-p/543056#M1128001 <HTML><HEAD></HEAD><BODY><P>Try</P><P>MakeDate (Year, Month, 01) AS Date</P><P>If 01 dont work use '01'</P></BODY></HTML> Sat, 07 Dec 2013 21:12:38 GMT https://community.qlik.com/t5/QlikView/Make-date/m-p/543056#M1128001 MK_QSL 2013-12-07T21:12:38Z