Peek function issue

Some modifications:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='D/M/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Date1:

LOAD * Inline [

id,date

1,1/2/2016

1,6/2/2016

1,7/2/2016

1,11/2/2016

1,13/2/2016

1,16/2/2016

1,21/2/2016

];

FinalDate:

LOAD id,

  date as Startdate,

    Date(If(Peek('id') = id, Previous(date), Today())) as Enddate

Resident Date1

Order By id, date DESC;

DROP Table Date1;

Vineeth -

I saw you added the If statement to check for id. I would also suggest to add id to order by statement ahead of date to make sure the ordering take place first by id and then by date