Hi all,
First of all thanks in advance for the future help.
I am struggling quite a littel bit with something that might be easy for top users.
I have this table:
| customer | date |
| Luis | 01/01/2019 |
| Carl | 01/01/2019 |
| John | 05/01/2019 |
| Luis | 03/01/2019 |
| Carl | 08/01/2019 |
| John | 10/01/2019 |
| Luis | 15/01/2019 |
| Carl | 16/01/2019 |
| John | 20/01/2019 |
And I want to process it and convert it into:
| customer | dateStart | datEnd |
| Luis | 01/01/2019 | 02/01/2019 |
| Carl | 01/01/2019 | 07/01/2019 |
| John | 05/01/2019 | 09/01/2019 |
| Luis | 03/01/2019 | 14/01/2019 |
| Carl | 08/01/2019 | 15/01/2019 |
| John | 10/01/2019 | 19/01/2019 |
| Luis | 15/01/2019 | 31/12/2999 |
| Carl | 16/01/2019 | 31/12/2999 |
| John | 20/01/2019 | 31/12/2999 |
Any idea? I guess it has to be easy but I cannot find the solution.
Kind regards
