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?
Retrieving data ...