Get data between date range
The default date format of sql server is yyyymmdd as you can see in the example
What you need to do is find a algorithm that gets the wanted date


CREATE TABLE table1 (
  ID INTEGER,
  StartDate DATE,
  EndDate DATE
);

INSERT INTO table1
  (ID, StartDate, EndDate)
VALUES
  ('1', '20210420', '2021-05-07'),
  ('2', '20210605', '20210606'),
  ('3', '20210501', '20210630'),
  ('4', '20210520', '20210530'),
  ('5', '20210429', '20210430'),
  ('6', '20210429', '20210429'),
  ('7', '20210505', '20210506'),
  ('8', '20210507', '20210508'),
  ('9', '20210510', '20210512'),
  ('10', '20210509', '20210510');
GO




SELECT DATEADD(DAY, (DATEDIFF(DAY, 0, GETDATE()) / 7) * 7 + 14, 0) AS NextDay



GO


| NextDay                 |
| :---------------------- |
| 2021-05-10 00:00:00.000 |




SELECT DATEADD(DAY, (DATEDIFF(DAY, 6, GETDATE()) / 7) * 7 + 14, 6) AS NextDay
GO


| NextDay                 |
| :---------------------- |
| 2021-05-09 00:00:00.000 |




SELECT ID, StartDate, EndDate FROM table1 
WHERE StartDate &gt;= DATEADD(DAY, (DATEDIFF(DAY, 0, GETDATE()) / 7) * 7 + 7, 0) 
AND (EndDate &lt;= DATEADD(DAY, (DATEDIFF(DAY, 6, GETDATE()) / 7) * 7 + 14, 6) 
    OR EndDate &lt;= DATEADD(DAY, (DATEDIFF(DAY, 0, GETDATE()) / 7) * 7 + 14, 0))
GO


ID | StartDate  | EndDate   
-: | :--------- | :---------
 7 | 2021-05-05 | 2021-05-06
 8 | 2021-05-07 | 2021-05-08
10 | 2021-05-09 | 2021-05-10


db&lt;&gt;fiddle here