Seth,

very nice. good explaination.

I have one question...

in the following code, isn't it returning the first of the week +/- 2 days?

SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 2)

--: 2010-03-01 00:00:00.000 Start of the day 2 days from now

SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), -2)

--: 2010-02-25 00:00:00.000 Start of the day 2 days ago.

Thanks,

Arkware