Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
For example, I have 2 dates : DateA = 18/12/2014 and DateB = 13/01/2015 (in format dd/mm/yyyy)
If I do DateB-DateA, I get 26 which is ok. (31-18) + 13 = 26
If I do NetWorkDays(DateA,DateB), I expect to obtain 18 because between Thursday 18th and Friday 13rd, there are 4 weekends so 8 weekend days, so I should obtain 26-8 = 18.
But I get 19.
Does NetworkDays include DateA and DateB in the count and so is not equal to : DateB-DateA - number of Sundays &Saturdays ?
Other question:
I would like to add some days in the holiday field. Those days are fixed every year (25th of December, 1st of January) is there a way to tell QV I want those days as holidays without having to write a list of those days for every year in my Qlikview (25/12/2000, 25/12/2001,...25/12/2015...) ?
Thank you for your help
Hi,
I think for simplicity it's best to include Year or you'll get to a stage of nesting variables to accommodate for current year.