topic FirstWorkDate in QlikView

FirstWorkDate

Anonymous — Wed, 11 Jun 2014 11:33:17 GMT

Hi all,

I need an advice, can we use FirstWorkDate() for Monday to Saturday work schedule?

If yes, then how?

Thanks in advance.

Yashada

Re: FirstWorkDate

senpradip007 — Wed, 11 Jun 2014 11:46:29 GMT

Its Monday to Friday.

Re: FirstWorkDate

Anonymous — Wed, 11 Jun 2014 11:48:03 GMT

Yes, but is there any way we can use that function for monday to saturday?

Re: FirstWorkDate

Gysbert_Wassenaar — Wed, 11 Jun 2014 11:48:36 GMT

No, the firstworkdate function treats saturdays as nonworking days. If you want a monday to saturday schedule simply check for sundays and remove those from the total number of days.

Re: FirstWorkDate

Fri, 04 Jul 2014 19:45:13 GMT

I am tearing my hair out over this.

My developers enter their plan for the next working day before going each day. (i.e. on Friday, July 4, they enter the data for Monday, July 7). The manager wants to see the report for the next working day each night around 7 pm.

I entered in the Search area of the PlanDay listbox the following:

=FirstWorkDate(today(1)+1,1). (I've tried with today(0) as well; same result)

I also have a text box on the page showing ='Today is '&today(1)

The text box shows "July 4, 2014", but when I enter the FirstWorkDate formula in the PlanDay listbox, it selects

July 4, not July 7.

How do I use this function to get the next working day?

thanks,

Re: FirstWorkDate

Gysbert_Wassenaar — Sat, 05 Jul 2014 09:05:24 GMT

Use the LastWorkDate function instead: LastWorkDate(today(1)+1,1)