Datediff in working days

[dinicholls]

Hi,

I'm trying to work out the days between the invoice date, and date paid, which I've done as and expression:

date(date_paid)-(date(invoice_date))

But........ is there any way I can change this so it gives the results in working days, and not just days?

Thanks

Di

[MK_QSL · Accepted solution]

Interval([date_paid]-[invoice_date],'D')

Or

NetWorkDays([invoice_date],[date_paid])

[dinicholls]

Manish,

Thank you!

Used NetWorkDays, worked a treat!

Di