topic Help with start date in QlikView https://community.qlik.com/t5/QlikView/Help-with-start-date/m-p/1080619#M930349 <HTML><HEAD></HEAD><BODY><P>My max Date is 03/03/2016.</P><P>I want to make the start of week as Sunday i.,e 02/28/2016</P><P>So I gave my expression as </P><P>=WeekStart(max(Date,0))</P><P></P><P>But it still returns start of week as 02/29/2016. Any help greatly appreciated.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Help with start date https://community.qlik.com/t5/QlikView/Help-with-start-date/m-p/1080619#M930349 <HTML><HEAD></HEAD><BODY><P>My max Date is 03/03/2016.</P><P>I want to make the start of week as Sunday i.,e 02/28/2016</P><P>So I gave my expression as </P><P>=WeekStart(max(Date,0))</P><P></P><P>But it still returns start of week as 02/29/2016. Any help greatly appreciated.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-start-date/m-p/1080619#M930349 2020-11-25T16:16:04Z Re: Help with start date https://community.qlik.com/t5/QlikView/Help-with-start-date/m-p/1080620#M930350 <HTML><HEAD></HEAD><BODY><P>Did you try this</P><P></P><P>=Date(WeekStart(Today())-1)</P><P>Or</P><P>=Date(WeekStart(DateField)-1)</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Tue, 15 Mar 2016 18:24:46 GMT https://community.qlik.com/t5/QlikView/Help-with-start-date/m-p/1080620#M930350 its_anandrjs 2016-03-15T18:24:46Z Re: Help with start date https://community.qlik.com/t5/QlikView/Help-with-start-date/m-p/1080621#M930351 <HTML><HEAD></HEAD><BODY><P>weekstart(Date,0,-1)</P><P></P><P>The third parameter is the offset from starting on Monday.</P></BODY></HTML> Tue, 15 Mar 2016 18:36:33 GMT https://community.qlik.com/t5/QlikView/Help-with-start-date/m-p/1080621#M930351 johnw 2016-03-15T18:36:33Z