declare @d datetime
set @d = '1/1/00'
select dateadd(dd, 2 - datepart(dw, @d), @d) as MondayDate

This page was last updated on May 01, 2006 04:28 PM.