I'm currently running data to pull weekend data. Below is the logic I'm using for both in my 'WHERE' statement....
Where (dw, dd.date) NOT IN ('Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday')
I was recently asked to include half of Monday on my weekend data (up till 12pm Monday). I need help updating my where clause to include half day monday on my SQL statement. To be clear, weekends should include all day Saturday, Sunday and 12am to 12pm Monday.