您也可以尝试以下语句:

you can also tried below statement:

select * from table where Date between dateadd(DD,-7,getdate()) and getdate()

可以尝试以下查询

Could try the following query

select * from table where Date between DATEADD(DD, -7, SYSDATETIME()) AND SYSDATETIME()