a range of dates

[alena_merkukhin]

Hi there!

there is a table with such data:

I need to do a range of dates of the next kind

Номер произ-го     Номер произ-го заказа          FromDate            ToDate

КОМЛЕКТОВКА               ЗПЗ-00001                         01.02.2018          02.02.2018

КОМЛЕКТОВКА               ЗПЗ-00001                         05.02.2018          05.02.2018

КОМЛЕКТОВКА               ЗПЗ-00001                         08.02.2018          09.02.2018

КОМЛЕКТОВКА               ЗПЗ-00001                         12.02.2018          12.02.2018

КОМЛЕКТОВКА               ЗПЗ-00001                         19.02.2018          22.02.2018

i.e  if the date goes one after another without any spaces, then the next date write in field ToDate. But if there are several such dates, for example, 19.02.2018,  20.02.2018, 21.02.2018, 22.02.2018, then on the field of ToDate select the maximum date 22.02.2018.

I tried using a Peek within a Load statement but can't get the desired result.

Any help would be appreciated!)