Hello everyone! I have a table called 'Activities' with a column 'Date' containing the dates of all the workouts. Starting from today's date, I would like to know for how many consecutive days I have been working out. If I skip a day, I would like the count to reset to zero. How can I do that? Thank you very much!
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |