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.