Basit Khan

Basit Khan

  • 1.7k
  • 295
  • 81.6k

Crew Scheduled

Jan 26 2020 1:00 PM
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.