I would like to select records that
are between last week's Monday and Sunday .I should be able to run it during any day of this week.
Is it possible to get a query that does Something like below
Select * from table where (This Week's Monday date - Table.RecordDate) < 8 ;
This query should fetch last weeks data irrespective of whatever day I run the query hthis week