I'm trying to pull all records between Monday and the day before.
For instance, on Thursday, I need the date range of Monday through Wednesday.
I've got a script that uses the following code:
SELECT * from dbo.events
WHERE dbo.events.eventdate BETWEEN DATEADD(wk,DATEDIFF(wk,7,getdate()),6) and getdate()
Open in new window
This gives the range a start day of Sunday. How should I modify it to treat Monday as the start of the week?
Thanks in advance.