topic firstworkdate of the week in QlikView https://community.qlik.com/t5/QlikView/firstworkdate-of-the-week/m-p/201631#M59640 <HTML><HEAD></HEAD><BODY><P>firstworkdate( end_date, no_of_workdays {, holiday} )<BR />Returns the latest starting date to acheive number_of_workdays<BR />(Monday-Friday) ending no later than end_date taking into account<BR />any optionally listed holidays. End_date and number_of_workdays<BR />should be valid dates or timestamps.</P></BODY></HTML> Fri, 25 Jun 2010 06:58:30 GMT 2010-06-25T06:58:30Z firstworkdate of the week https://community.qlik.com/t5/QlikView/firstworkdate-of-the-week/m-p/201629#M59638 <HTML><HEAD></HEAD><BODY><P>i have brough a week from my date column now i need to take the first day of selected week..... what is function in qlikview..... ?</P></BODY></HTML> Fri, 25 Jun 2010 06:21:01 GMT https://community.qlik.com/t5/QlikView/firstworkdate-of-the-week/m-p/201629#M59638 2010-06-25T06:21:01Z firstworkdate of the week https://community.qlik.com/t5/QlikView/firstworkdate-of-the-week/m-p/201630#M59639 <HTML><HEAD></HEAD><BODY><P>WeekStart( date [, shift = 0 [,weekoffset = 0]] )<BR />Returns a value corresponding to a timestamp with the first millisecond<BR />of the first date ( Monday ) of the calendar week containing<BR />date. The default output format will be the DateFormat set in the<BR />script. Shift is an integer, where the value 0 indicates the week<BR />which contains date. Negative values in shift indicate preceding<BR />weeks and positive values indicate succeeding weeks. If you want to<BR />work with weeks not starting midnight between Sunday and Monday,<BR />you may indicate an offset in days in weekoffset. This may be<BR />given as a real number indicating days and/or fractions of a day</P></BODY></HTML> Fri, 25 Jun 2010 06:55:03 GMT https://community.qlik.com/t5/QlikView/firstworkdate-of-the-week/m-p/201630#M59639 2010-06-25T06:55:03Z firstworkdate of the week https://community.qlik.com/t5/QlikView/firstworkdate-of-the-week/m-p/201631#M59640 <HTML><HEAD></HEAD><BODY><P>firstworkdate( end_date, no_of_workdays {, holiday} )<BR />Returns the latest starting date to acheive number_of_workdays<BR />(Monday-Friday) ending no later than end_date taking into account<BR />any optionally listed holidays. End_date and number_of_workdays<BR />should be valid dates or timestamps.</P></BODY></HTML> Fri, 25 Jun 2010 06:58:30 GMT https://community.qlik.com/t5/QlikView/firstworkdate-of-the-week/m-p/201631#M59640 2010-06-25T06:58:30Z