Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To get networkdays

Dear Members,

I want to calculate networkdays between 25-04-2009 11:01:05 to 04-05-2009 08:01:58

I tried like this networkdays('25-04-2009','04-05-2009','01-05-2009')  then I got 5 working days

but when I used date along with timestamp it also give 5 working days which wrong.

Am doing wrong, Please give me suggestion.

Thanks & Regards,

Yogesh

1 Reply
Not applicable
Author

I had this problem few days back.

so i used networkdays as well as interval both

like

if

(

Interval((date2- date1), 'mm') < 0

,

num((-1)*(networkdays(date2,date1) -1), '00') & ' days ' & subfield(interval(date2- date1, 'DD hh:mm:ss'), ' ' , 2)

,

'DD hh:mm:ss'), ' ' , 2)

num(networkdays(date2,date1), '00') & ' days ' & subfield(interval(date2- date1, 'DD hh:mm:ss'), ' ' , 2)

)