topic Re: MakeWeekDate in QlikView https://community.qlik.com/t5/QlikView/MakeWeekDate/m-p/830906#M998349 <HTML><HEAD></HEAD><BODY><P class="syntax"><A name="kanchor479"></A><A name="MakeWeekDate"></A><SPAN class="Bold">MakeWeekDate(</SPAN><SPAN class="Italic">YYYY [ , WW [ , D ] ] </SPAN><SPAN class="Bold">)</SPAN> </P><P>Returns a date calculated from the year <SPAN class="Italic">YYYY</SPAN>, the week <SPAN class="Italic">WW</SPAN> and the day-of-week <SPAN class="Italic">D</SPAN>. </P><P>If no day-of-week is stated, 0 (Monday) is assumed. </P><P class="example">Examples:</P><P><SPAN class="Code">makeweekdate(1999,6,6)</SPAN> returns 1999-02-14</P><P><SPAN class="Code">makeweekdate(1999,6)</SPAN> returns 1999-02-08</P><P></P><P>In your example, you are requesting the date for the 6th day of week 6 in year 1999 (week numbering and week days according ISO).</P></BODY></HTML> Tue, 16 Jun 2015 15:14:10 GMT swuehl 2015-06-16T15:14:10Z MakeWeekDate https://community.qlik.com/t5/QlikView/MakeWeekDate/m-p/830905#M998348 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; How does qlikview interprets it</P><P>&nbsp;&nbsp;&nbsp; <SPAN class="Code">makeweekdate(1999,6,6)</SPAN> returns 1999-02-14</P><P></P><P>With Regards,</P><P>Sudharshan</P></BODY></HTML> Tue, 16 Jun 2015 10:30:49 GMT https://community.qlik.com/t5/QlikView/MakeWeekDate/m-p/830905#M998348 2015-06-16T10:30:49Z Re: MakeWeekDate https://community.qlik.com/t5/QlikView/MakeWeekDate/m-p/830906#M998349 <HTML><HEAD></HEAD><BODY><P class="syntax"><A name="kanchor479"></A><A name="MakeWeekDate"></A><SPAN class="Bold">MakeWeekDate(</SPAN><SPAN class="Italic">YYYY [ , WW [ , D ] ] </SPAN><SPAN class="Bold">)</SPAN> </P><P>Returns a date calculated from the year <SPAN class="Italic">YYYY</SPAN>, the week <SPAN class="Italic">WW</SPAN> and the day-of-week <SPAN class="Italic">D</SPAN>. </P><P>If no day-of-week is stated, 0 (Monday) is assumed. </P><P class="example">Examples:</P><P><SPAN class="Code">makeweekdate(1999,6,6)</SPAN> returns 1999-02-14</P><P><SPAN class="Code">makeweekdate(1999,6)</SPAN> returns 1999-02-08</P><P></P><P>In your example, you are requesting the date for the 6th day of week 6 in year 1999 (week numbering and week days according ISO).</P></BODY></HTML> Tue, 16 Jun 2015 15:14:10 GMT https://community.qlik.com/t5/QlikView/MakeWeekDate/m-p/830906#M998349 swuehl 2015-06-16T15:14:10Z Re: MakeWeekDate https://community.qlik.com/t5/QlikView/MakeWeekDate/m-p/830907#M998350 <HTML><HEAD></HEAD><BODY><P>day of week&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt; sunday (3rd parameter)</P><P>week&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt; of the 6th week (2nd parameter)</P><P>year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1999&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --&gt; of year 1999 (1st parameter)</P><P></P><P>is (I think)&nbsp; the date 14 feb 1999</P></BODY></HTML> Tue, 16 Jun 2015 15:17:10 GMT https://community.qlik.com/t5/QlikView/MakeWeekDate/m-p/830907#M998350 maxgro 2015-06-16T15:17:10Z