Hello,
I have a table like this:
<tbody>
</tbody>
I need to combine the dates for each row with the same ID1 and ID2 (Startdate should be the oldest and the Enddate should be the newest). I should get a table like this:
<tbody>
</tbody>
Can someone help me?
I have a table like this:
ID1 | ID2 | Startdate | Enddate |
MS | PT668 | 14-11-2015 | 15-10-2016 |
MS | PT668 | 16-10-2016 | 31-12-9999 |
WZ | PT443 | 15-03-2014 | 16-10-2016 |
WZ | PT443 | 17-10-2016 | 28-12-2016 |
WZ | PT320 | 29-12-2016 | 31-12-9999 |
AT | PT123 | 01-07-2016 | 31-12-9999 |
<tbody>
</tbody>
I need to combine the dates for each row with the same ID1 and ID2 (Startdate should be the oldest and the Enddate should be the newest). I should get a table like this:
ID1 | ID2 | Startdate | Enddate |
MS | PT668 | 14-11-2015 | 31-12-9999 |
WZ | PT443 | 15-03-2014 | 28-12-2016 |
WZ | PT320 | 29-12-2016 | 31-12-9999 |
AT | PT123 | 01-07-2016 | 31-12-9999 |
<tbody>
</tbody>
Can someone help me?