Select last 7 days record from current Date in SQL Server

Hi iammann,

Refer below sample query.

SQL

DECLARE @tblWeekData AS TABLE(ClientId INT IDENTITY, Name VARCHAR(20), Country VARCHAR(20), Amount INT, Last_Modified_Date DATETIME)
INSERT INTO @tblWeekData VALUES('Mudassar Khan','India',100,'2019-07-05')
INSERT INTO @tblWeekData VALUES('John Hammond','United States',100,'2019-07-06')
INSERT INTO @tblWeekData VALUES('Suzanne Mathews','France',100,'2019-07-07')
INSERT INTO @tblWeekData VALUES('Mudassar Khan','India',100,'2019-07-08')
INSERT INTO @tblWeekData VALUES('Suzanne Mathews','France',100,'2019-07-09')
INSERT INTO @tblWeekData VALUES('Mudassar Khan','India',100,'2019-07-10')
INSERT INTO @tblWeekData VALUES('Mudassar Khan','India',100,'2019-07-11')
INSERT INTO @tblWeekData VALUES('Suzanne Mathews','France',100,'2019-07-12')
INSERT INTO @tblWeekData VALUES('John Hammond','United States',100,'2019-07-13')
INSERT INTO @tblWeekData VALUES('Mudassar Khan','India',100,'2019-07-14')
INSERT INTO @tblWeekData VALUES('John Hammond','United States',100,'2019-07-15')
INSERT INTO @tblWeekData VALUES('Mudassar Khan','India',100,'2019-07-16')
INSERT INTO @tblWeekData VALUES('Mudassar Khan','India',100,'2019-07-17')
INSERT INTO @tblWeekData VALUES('Mudassar Khan','India',100,'2019-07-18')

DECLARE @CurrentDate DATETIME
SET @CurrentDate = '2019/07/12'
DECLARE @From DATETIME
SET @From = @CurrentDate - 7
DECLARE @To DATETIME
SET @To = @CurrentDate - 1
DECLARE @WeekDays VARCHAR(20)
SET @WeekDays = (SELECT DATENAME(dw,@CurrentDate))
IF (@WeekDays = 'Friday')
	SELECT * FROM @tblWeekData WHERE Last_Modified_Date BETWEEN @From AND @To
ELSE
PRINT 'Nothing'

Output