Best solution intervalmatch. peek or other

[roberto99]

Hi, I have doubts about how is the most effective way to solve this problem; 

the "USUARIOS" table contains "incomplete" dates, USUARIOS and TIPO, with respect to the "VTAS" table; I want to obtain the table "RESULTADOS", which would be the most efficient option, the calendar would be from today 13 months ago

Thanks for the help

[MayilVahanan · Accepted solution]

HI @roberto99 

Try with intervalmatch concept.

In USUARIOS table, you can bring EndDate based on next date-1  for each Tipo.

Hope it helps.

[roberto99]

OK, THANKS