topic Firstworkdate function issue. in QlikView https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339144#M831782 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>When we use firstworkdate() function it excludes Saturdays and Sundays, but I want to include Saturday as my working day, so what should i do? Is there any other function to calculate the same? Or any other method Please help?</P><P></P><P>Thanks in advance.</P><P></P><P>-CS</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Firstworkdate function issue. https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339144#M831782 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>When we use firstworkdate() function it excludes Saturdays and Sundays, but I want to include Saturday as my working day, so what should i do? Is there any other function to calculate the same? Or any other method Please help?</P><P></P><P>Thanks in advance.</P><P></P><P>-CS</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339144#M831782 2020-11-25T16:16:04Z Re: Firstworkdate function issue. https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339145#M831783 <HTML><HEAD></HEAD><BODY><P>There is no standard option to include Saturdays as working days. If you are using a master calendar, then it is easy enough to create a workday flag that is set for Monday - Saturday. Then you can create expressions using this flag - for example NetWorkDays(..) becomes a count/sum of the flag values.</P></BODY></HTML> Thu, 22 Jun 2017 06:28:55 GMT https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339145#M831783 jonathandienst 2017-06-22T06:28:55Z Re: Firstworkdate function issue. https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339146#M831784 <HTML><HEAD></HEAD><BODY><P>Thank You Jonathan for quick reply. This might help. </P></BODY></HTML> Thu, 22 Jun 2017 06:42:03 GMT https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339146#M831784 2017-06-22T06:42:03Z Re: Firstworkdate function issue. https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339147#M831785 <HTML><HEAD></HEAD><BODY><P>Hi Chiranjeev</P><P></P><P>Maybe this</P><P></P><P>=date(FirstWorkDate(today(),v_n_days)</P><P>+Div(WEEKDAY(today()-v_n_days-6)+1-(today()-v_n_days)+today(),7))</P><P></P><P>where v_n_days is no. of days from firstworkdate which is today.</P><P></P><P>Regards<BR />Pratyush</P></BODY></HTML> Thu, 22 Jun 2017 06:42:55 GMT https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339147#M831785 prat1507 2017-06-22T06:42:55Z Re: Firstworkdate function issue. https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339148#M831786 <HTML><HEAD></HEAD><BODY><P>Thank You Pratyush, It works.</P></BODY></HTML> Thu, 22 Jun 2017 07:06:06 GMT https://community.qlik.com/t5/QlikView/Firstworkdate-function-issue/m-p/1339148#M831786 2017-06-22T07:06:06Z