Select last 7 days records from VARCHAR column from database in SQL server

Hi Logic24,

Please take reference below sql query correct your query.

SQL

DECLARE @DateRecord AS TABLE( DateOfJoining VARCHAR(50))

INSERT INTO @DateRecord VALUES('26-June-2018')
INSERT INTO @DateRecord VALUES('25-June-2018 ')
INSERT INTO @DateRecord VALUES('23-June-2018')
INSERT INTO @DateRecord VALUES('22-June-2018')
INSERT INTO @DateRecord VALUES('21-June-2018')
INSERT INTO @DateRecord VALUES('20-June-2018')
INSERT INTO @DateRecord VALUES('19-June-2018')
INSERT INTO @DateRecord VALUES('18-June-2018')
INSERT INTO @DateRecord VALUES('17-June-2018')

SELECT DateOfJoining
FROM @DateRecord
WHERE CAST(DateOfJoining AS DATETIME) BETWEEN DATEADD(DAY,-8,GETDATE()) AND GETDATE()

Output