[RESOLVED] getting from date of week to date of week

[techgnome]

Except that's not in SQL....

I'm trying to get a date of week to date of week in SQL.

I'm not sure I'm 100% clear on what the question is...
Odds are though, it's going to involve DatePart, DateAdd and a loop of some kind.

-tg