Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Karahs
Partner - Creator
Partner - Creator

NetworkDays problem!

Hello everyone,


Having NetworkDays with same Start Date and End Date gives Value as 1 i want it as 0,

Tried using if(start date=end date,0,networkdays(Startdate,enddate)) Still Giving output as 1...y is it so??

Thanks&Regards

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Does your start date and end date also have time stamps?

try this instead


= if(FLOOR(NUM(start date))=FLOOR(NUM(end date)),0,networkdays(Startdate,enddate))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

3 Replies
vinieme12
Champion III
Champion III

Does your start date and end date also have time stamps?

try this instead


= if(FLOOR(NUM(start date))=FLOOR(NUM(end date)),0,networkdays(Startdate,enddate))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Karahs
Partner - Creator
Partner - Creator
Author

Hello Vineeth ,

Thankyou it worked .

vinieme12
Champion III
Champion III

Happy to help

Cheers

V

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.