Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
didierfarineau
Contributor
Contributor

Issue in the function networkdays

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

1 Solution

Accepted Solutions
didierfarineau
Contributor
Contributor
Author

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

View solution in original post

1 Reply
didierfarineau
Contributor
Contributor
Author

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

View solution in original post