0 Replies Latest reply on Jan 4, 2019 11:42 AM by

    How to modify this query to auto pull from Monday to Sunday of the previous week?

      Hey All,


      I need to modify the below Where statement to auto pull the information from the previous week.


      WHERE T0.[DocDate] >= [%0] AND T0.[DocDate] <= [%1]


      I have attempted to use the GETDATE function without luck:


      WHERE T0.[DocDate] = DATEADD(WW,-1,GETDATE())


      Would someone be able to assist?