topic Re: Creating Date field from two separate fields for Year and Month in QlikView https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668886#M676828 <HTML><HEAD></HEAD><BODY><P>MakeDate(Year,Month,1) as Date</P></BODY></HTML> Thu, 12 Jun 2014 12:37:03 GMT tresB 2014-06-12T12:37:03Z Creating Date field from two separate fields for Year and Month https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668881#M676823 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have two separate fields for Year and Month.</P><P>can I create a date field from it?? Days I can take random.</P><P></P><P>Please help....</P></BODY></HTML> Thu, 12 Jun 2014 12:02:00 GMT https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668881#M676823 alkesh_sharma 2014-06-12T12:02:00Z Re: Creating Date field from two separate fields for Year and Month https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668882#M676824 <HTML><HEAD></HEAD><BODY><P>You can use Date(Date#(Year&amp;MONTH,'YYYYMM')). it'll give the start date for that month.</P></BODY></HTML> Thu, 12 Jun 2014 12:04:48 GMT https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668882#M676824 2014-06-12T12:04:48Z Re: Creating Date field from two separate fields for Year and Month https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668883#M676825 <HTML><HEAD></HEAD><BODY><P>Hello Krupasagar,</P><P></P><P>Its not working...is there any other option??</P></BODY></HTML> Thu, 12 Jun 2014 12:23:40 GMT https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668883#M676825 alkesh_sharma 2014-06-12T12:23:40Z Re: Creating Date field from two separate fields for Year and Month https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668884#M676826 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>insert dates</P><P>1,</P><P>2,</P><P>.</P><P>.</P><P>.</P><P>.</P><P>31,</P></BODY></HTML> Thu, 12 Jun 2014 12:27:00 GMT https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668884#M676826 Anonymous 2014-06-12T12:27:00Z Re: Creating Date field from two separate fields for Year and Month https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668885#M676827 <HTML><HEAD></HEAD><BODY><P>Hi Sharma, Try with MakeDate function like below:</P><P></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; MakeDate(YEARFIELD, MONTH) AS DATEFIELD</STRONG></P><P></P><P>If you ignore day parameter, it takes 1st of month.</P></BODY></HTML> Thu, 12 Jun 2014 12:33:43 GMT https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668885#M676827 2014-06-12T12:33:43Z Re: Creating Date field from two separate fields for Year and Month https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668886#M676828 <HTML><HEAD></HEAD><BODY><P>MakeDate(Year,Month,1) as Date</P></BODY></HTML> Thu, 12 Jun 2014 12:37:03 GMT https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668886#M676828 tresB 2014-06-12T12:37:03Z Re: Creating Date field from two separate fields for Year and Month https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668887#M676829 <HTML><HEAD></HEAD><BODY><P>Nope, still not working... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 12 Jun 2014 12:58:55 GMT https://community.qlik.com/t5/QlikView/Creating-Date-field-from-two-separate-fields-for-Year-and-Month/m-p/668887#M676829 alkesh_sharma 2014-06-12T12:58:55Z