Hey guys!
I have a table with this format:
<tbody>
</tbody>
Now I have this aim:
I have a table that lists all IDs.
Now I want to know, if somebody have any entrys 3 weekends in a row.
So, the guy above have worked 3 weekends in a row.
How can I get this informationen?
Especially, if there is a year change.
Does anyone have any idea?
Best regards
I have a table with this format:
ID | Date | Day | Value |
1 | 31.12.2017 | So | 7 |
1 | 01.01.2018 | Mo | 8 |
1 | 06.01.2018 | Sa | 9 |
1 | 13.01.2018 | Sa | 8 |
1 | 14.01.2018 | So | 8 |
1 | 15.01.2018 | Mo | 7 |
2 | 01.01.2018 | Mo | 4 |
<tbody>
</tbody>
Now I have this aim:
I have a table that lists all IDs.
Now I want to know, if somebody have any entrys 3 weekends in a row.
So, the guy above have worked 3 weekends in a row.
How can I get this informationen?
Especially, if there is a year change.
Does anyone have any idea?
Best regards