negative days in networksdays

[#1]

I use the networkdays to calculate the number of days between two dates

NetWorkDays(Confirmed_Date,Invoice_Date) as Diff,

All is fine as long as the difference is a positive number, but when it is a negative number all I get is -1, irrespective of the actual difference.

What can i do to get the actual negative number of days.

Thanks!

[syed_muzammil]

Hi,

You can try this.

if(Confirmed_Date<Invoice_Date,

NetWorkDays(Confirmed_Date,Invoice_Date,

-NetWorkDays(Invoice_Date,Confirmed_Date)), as Diff

Regards,

Syed.