Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody, I'm marco and i'm from Italy.
I have a big problem.
Someone knows a function that returns me the number of non-working days (Sat, Sun) between two dates?
thank you
HI,
Have a look at this example. You will find this in help of qlikview.
Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.
networkdays ('2007-02-19', '2007-03-01') returns 9
networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8
Using this you will get the no. of working days..
To get non working days you can do this ( count the total days - working days.)
Regards,
Kaushik Solanki
HI,
Have a look at this example. You will find this in help of qlikview.
Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.
networkdays ('2007-02-19', '2007-03-01') returns 9
networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8
Using this you will get the no. of working days..
To get non working days you can do this ( count the total days - working days.)
Regards,
Kaushik Solanki