Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
)