Yup!!

Missed the time issue. 

Thanks

Daizy

little simplified...

select * from tblname WHERE datecol>= DATEADD(DAY,-7,GETDATE())

Or

SELECT * FROM tblnameWHERE datecol BETWEEN dateadd(DAY,-7,GETDATE()) AND dateadd(day,1,GETDATE())