I need a query that pulls data from last week (Monday through Sunday). It should not matter what day it is now, if it's Monday, or Friday... I want to only pull data from last week.
I tried using r.rundate between GetDate()-7 and GetDate(); but this only pulls the data from the last seven days. I want to pull all of last week.
Thanks in advance!