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.