Relative Content

Tag Archive for sqlcasedeclaregetdate

How to modify query run based on the day of the week?

I have a code that runs every weekday looking for the previous day, however on Mondays it looks from past Friday through Sunday. Right now, I am manually commenting in and out rows of code if it’s a Monday. How can I have it combined without having to touch it every Monday? I use placeholders to declare dates that will be used further down the code.