Exclude Saturday and Sunday

[chandra63]

Hi All,

I have sample Expression.

if([EMI Amount] <= [RZ\Wav Amount] and date([Installment Due Date]+3)>=[Wav\RZ Date],'NOT OD',
if([EMI Amount] >= [RZ\Wav Amount] and match(Status,'01','02','04','06','10'),'OD',
if([EMI Amount] <= [RZ\Wav Amount] and date([Installment Due Date]+3)<[Wav\RZ Date],'Recovered'))) as OD_Details.

it is working fine. But User want to Exclude weekends .

Instead of   3 in expression we want to show 3 working days.

how i can achieve that.

Can anyone suggest an idea to me?

Thank you for interesting.

Regards.

Chandra

[hopkinsc]

Try using the networkdays function

Networkdays

[chandra63]

Hi,

how can i take 3 networkdays .

date([Installment Due Date]+3*Networkdays) i tried like this .but it not working

[hopkinsc]

what about 

networkdays(date([Installment Due Date]+3))

see if that works

[chandra63]

Hi,

It is not working fine..

Thanks.

[chandra63]

Hi,

we have to show  installment  plus 3 working days .

ex:

installment_Date + 3(installment_dates). which has to exclude weekends