topic Week Ending Syntax in QlikView https://community.qlik.com/t5/QlikView/Week-Ending-Syntax/m-p/843895#M1010129 <HTML><HEAD></HEAD><BODY><P>I have a date field that needs to be converted to a week end date. The week ends on Tuesdays so the date should always convert to the following Tuesday unless the date is Tuesday itself then the value is fine.</P><P></P><P>How can this be setup in the load script? Thank you so much for the help!</P></BODY></HTML> Tue, 28 Apr 2015 17:49:00 GMT 2015-04-28T17:49:00Z Week Ending Syntax https://community.qlik.com/t5/QlikView/Week-Ending-Syntax/m-p/843895#M1010129 <HTML><HEAD></HEAD><BODY><P>I have a date field that needs to be converted to a week end date. The week ends on Tuesdays so the date should always convert to the following Tuesday unless the date is Tuesday itself then the value is fine.</P><P></P><P>How can this be setup in the load script? Thank you so much for the help!</P></BODY></HTML> Tue, 28 Apr 2015 17:49:00 GMT https://community.qlik.com/t5/QlikView/Week-Ending-Syntax/m-p/843895#M1010129 2015-04-28T17:49:00Z Re: Week Ending Syntax https://community.qlik.com/t5/QlikView/Week-Ending-Syntax/m-p/843896#M1010130 <HTML><HEAD></HEAD><BODY><P>use </P><P></P><P>date(floor(weekend(yourdate,0,2)))</P></BODY></HTML> Tue, 28 Apr 2015 18:27:30 GMT https://community.qlik.com/t5/QlikView/Week-Ending-Syntax/m-p/843896#M1010130 ramoncova06 2015-04-28T18:27:30Z Re: Week Ending Syntax https://community.qlik.com/t5/QlikView/Week-Ending-Syntax/m-p/843897#M1010131 <HTML><HEAD></HEAD><BODY><P>You can use the WeekEnd function. The third parameter can be used to specify an offset in case the last day of the week is not Sunday. So WeekEnd(MyDate, 0, 2) should do the trick.</P></BODY></HTML> Tue, 28 Apr 2015 18:36:04 GMT https://community.qlik.com/t5/QlikView/Week-Ending-Syntax/m-p/843897#M1010131 Gysbert_Wassenaar 2015-04-28T18:36:04Z