4 Replies Latest reply: Feb 10, 2014 4:25 AM by Alejandro Hernandez RSS

    How to exclude weekends on queries?


      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