You could try something like

[font="Courier New"]select * from Table where DATEPART(wk, DateField) = DATEPART(wk, GETDATE())[/font]

That would give you all rows from this week.