How to exclude weekends on queries?

[#1]

Hi,

May I know how will I excempt weekends for my query below? My condition should only count working days..

if([POSTING DATE]-[Date of Transmittal]<=2,'Within','Over') as PaymentSLA,

Thank you

[preminqlik]

try like this

if(networkingdays([POSTING DATE],[Date if Transmittal])<=2,'Within','Over')          as               PaymentSLA

[#3]

Hi,

It didnt work. It all fell to within SLA. As per checking the raw data, there should be some over SLA.

Thank you

[tresesco]

The function is NetWorkDays(). With proper use, it should work. If you can't get it worked, try to share your sample app here.

[Alejandro_Hernández]

try with

if((NetWorkDays([Date of Transmittal],[POSTING DATE])<=2),'Within','Over') as   PaymentSLA