SQL Server 2008

Get First Day & Last Day of Last Week

I have a requirement to generate data for reporting for the previous week, where the week starts on a Monday and ends on a Sunday.The requirement being that Monday begins at midnight and Sunday ends milliseconds before midnight.

I hope that helps!

Share on Google Plus


Australian. Sport. Passionate Cricket Fan. Go Pro. Abseiling. Snorkeling. Travel. Golf R. SQL Server Developer. Three sons. One daughter. Last Trip: Tasmania.

Leave a comment

Your email address will not be published. Required fields are marked *