• Code below will return Thursday from the current week for the @Date supplied. You can modify your where clause to use this date as FROM DATE and DATEADD(DAY,-7, THISDATE) as TO DATE

    DECLARE @DATE AS DATETIME

    SET @DATE='2013-08-28'

    SELECT DATEADD(DAY, 5- DATEPART(dw, @DATE ), @DATE)