topic To get networkdays in QlikView

To get networkdays

Wed, 11 May 2011 10:51:43 GMT

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

Wed, 11 May 2011 11:03:00 GMT

I had this problem few days back.

so i used networkdays as well as interval both

(

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)

)