topic Combine Year with month/day in QlikView https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224273#M857442 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have year colum separately and month date colum as "mm, dd" .</P><P>I want to combine this and make date when loading.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT anuradhaa 2020-11-25T16:16:04Z Combine Year with month/day https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224273#M857442 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have year colum separately and month date colum as "mm, dd" .</P><P>I want to combine this and make date when loading.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224273#M857442 anuradhaa 2020-11-25T16:16:04Z Re: Combine Year with month/day https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224274#M857443 <HTML><HEAD></HEAD><BODY><P>try this</P><P>makedate('2017',mm,dd)</P></BODY></HTML> Tue, 07 Feb 2017 04:09:13 GMT https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224274#M857443 arulsettu 2017-02-07T04:09:13Z Re: Combine Year with month/day https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224275#M857444 <HTML><HEAD></HEAD><BODY><P>i have several year so it doesnot work, </P><P></P><P>Date(Date#((tempYear &amp; ',' &amp; Date),'YYYY,MMM, DD'), 'YYYY-MMM-DD') as mydate, solve the issue</P><P></P><P>Thanks</P></BODY></HTML> Tue, 07 Feb 2017 04:12:04 GMT https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224275#M857444 anuradhaa 2017-02-07T04:12:04Z Re: Combine Year with month/day https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224276#M857445 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000080; font-family: 'courier new', courier;">Hi please try per the attached QVW, this might help</SPAN></P></BODY></HTML> Tue, 07 Feb 2017 04:27:34 GMT https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224276#M857445 punitpopli 2017-02-07T04:27:34Z Re: Combine Year with month/day https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224277#M857446 <HTML><HEAD></HEAD><BODY><P>It should be </P><P>Date (MakeDate(tempYear,monthfield),'YYYY-MMM-DD') as datefield</P></BODY></HTML> Tue, 07 Feb 2017 05:17:29 GMT https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224277#M857446 vinieme12 2017-02-07T05:17:29Z Re: Combine Year with month/day https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224278#M857447 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">you can create like below also</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Year&amp;'-'&amp;Month&amp;'-'&amp;Date as&nbsp; salesYearMD</STRONG></P></BODY></HTML> Tue, 07 Feb 2017 06:57:41 GMT https://community.qlik.com/t5/QlikView/Combine-Year-with-month-day/m-p/1224278#M857447 ramasaisaksoft 2017-02-07T06:57:41Z