Agree with others.
You can use SQL Server agent job and write a stored procedure that deletes every rows that date is passed today's date.
CREATE PROCEDURE DeleteRows() AS BEGIN DELETE FROM Table WHERE DateColumn < GETDATE() END
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.