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?