Issue in the function networkdays

[Anonymous]

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

[Anonymous · Accepted solution]

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