Generate Calendar (Start Date and Start End) for Effective Dates

[lfalmoguera]

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

[lfalmoguera]

Very interisting. Will try to use it.