topic Dates in QlikView https://community.qlik.com/t5/QlikView/Dates/m-p/467627#M695092 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to extract from my calendar the last sunday of the month</P><P></P><P>how can i do this?</P><P></P><P>tnks!</P></BODY></HTML> Wed, 12 Jun 2013 20:41:38 GMT 2013-06-12T20:41:38Z Dates https://community.qlik.com/t5/QlikView/Dates/m-p/467627#M695092 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to extract from my calendar the last sunday of the month</P><P></P><P>how can i do this?</P><P></P><P>tnks!</P></BODY></HTML> Wed, 12 Jun 2013 20:41:38 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/467627#M695092 2013-06-12T20:41:38Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/467628#M695093 <HTML><HEAD></HEAD><BODY><P>May similar to this?</P><P></P><P>TempCalendar:</P><P>LOAD Date(makedate(2013)+recno()) as TempDate </P><P>AutoGenerate 500;</P><P></P><P>Calendar:</P><P>LOAD *, weekday(LastSunday) as Test;</P><P>LOAD Date(max(if(weekday(TempDate)=6,TempDate))) as LastSunday</P><P>Resident TempCalendar </P><P>group by monthstart(TempDate);</P></BODY></HTML> Wed, 12 Jun 2013 21:16:21 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/467628#M695093 swuehl 2013-06-12T21:16:21Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/467629#M695094 <HTML><HEAD></HEAD><BODY><P>Tnks Swuehl!!</P></BODY></HTML> Thu, 13 Jun 2013 13:42:52 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/467629#M695094 2013-06-13T13:42:52Z