Crew Scheduled

Question

Dear,

I have a table Called Crew Scheduled.

What im looking for with current date search and to get From Date and To Date

Example-1: If Current Date is 21-01-2020 the Crew-A FromDate is 19-01-2020 and ToDate is 24-01-2020

Example-2: If Current Date is 21-01-2020 the Crew-B FromDate is 25-01-2020 and ToDate is 29-01-2020

How to get this

 

The Table is.

 

ShedNo	Crew	Type	Date
1	A	OD	19-01-2020
2	A	OD	20-01-2020
3	A	OD	21-01-2020
4	A	OD	22-01-2020
5	A	OD	23-01-2020
6	A	OD	24-01-2020
7	A	RS	03-02-2020
8	A	RS	04-02-2020
9	A	RS	05-02-2020
10	A	RS	06-02-2020
11	A	RS	07-02-2020
12	B	OD	13-01-2020
13	B	OD	14-01-2020
14	B	OD	15-01-2020
15	B	OD	16-01-2020
16	B	OD	17-01-2020
17	B	RS	25-01-2020
18	B	RS	26-01-2020
19	B	RS	28-01-2020
20	B	RS	29-01-2020

  

Thanks

Basit.