Delete dates

Hi,

I have a set of dates and want to delete all the data from a table with the newest dates(i think its that way around) keeping the oldest.

12/31/2023
12/22/2023
12/15/2023
12/8/2023
12/1/2023
11/30/2023
11/24/2023
11/17/2023
11/10/2023
11/3/2023
10/31/2023
10/27/2023
10/20/2023
10/13/2023
10/6/2023
9/29/2023
9/22/2023
9/15/2023
9/8/2023
9/1/2023
8/31/2023
8/25/2023
8/18/2023
8/11/2023
8/4/2023
7/31/2023
7/28/2023
7/21/2023
7/14/2023
7/7/2023
delete all dates but the 12/31/2023

file could also be

6/30/2023
6/22/2023
6/16/2023
6/9/2023
6/2/2023
5/31/2023
5/26/2023
5/19/2023
5/12/2023
5/5/2023
4/28/2023
4/21/2023
4/14/2023
4/6/2023
3/31/2023
3/24/2023
3/17/2023
3/10/2023
3/3/2023
2/28/2023
2/24/2023
2/17/2023
2/10/2023
2/3/2023
1/31/2023

so deleting all dates but 30/06/2023

DELETE FROM dbo.tablename
WHERE date < (SELECT MAX(date) FROM dbo.?other?tablename)