negative days in networksdays

Wed, 20 Oct 2010 12:10:56 GMT

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 — Wed, 20 Oct 2010 12:17:28 GMT

Hi,

You can try this.

if(Confirmed_Date<Invoice_Date,

NetWorkDays(Confirmed_Date,Invoice_Date,

-NetWorkDays(Invoice_Date,Confirmed_Date)), as Diff

Regards,

Syed.

topic negative days in networksdays in QlikView