Michael Valentine Jones (8/23/2011)

---

paul_ramster (8/23/2011)

---

That's the same algorithm I posted further up the thread, although rather better explained.

The only assumption that is made is that you know a Monday, which in your case is day 0.

I rather unnecessarily tied myself in knots trying to make that assumption explicit and avoid dates before February 1900, to avoid leap year confusions.

If you are concerned about dates before 1900-01-01, then you could use 1753-01-01, which is the earliest possible datetime and also a Monday. Ask me how I knew that. 🙂

Start of Week Function

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307