Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
There are a error on the function Networkdays in QV
if i run the script below the result is correct --> 7 Days
=NetWorkDays('20121120','20121128')
But if i run the same script in 2 month different the result is false --> 72 Days
=NetWorkDays('20121120','20121220')
I think it's a issue of date format but i don't find the solution
Thank you for your help
I found the solution it was a problem of date format
my format is SET DateFormat = 'YYYY-MM-DD';
by changing the function
= Networkdays ( '2012-01-13', '2012-02-20')
and now it works
I found the solution it was a problem of date format
my format is SET DateFormat = 'YYYY-MM-DD';
by changing the function
= Networkdays ( '2012-01-13', '2012-02-20')
and now it works