Issue in the function networkdays

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Issue in the function networkdays

Anonymous — Mon, 05 Mar 2018 12:59:56 GMT

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