Populate values of next record in previous record
Posted: Sat Sep 09, 2017 8:01 pm
Hello all,
I have 5 records as below
I need to pick next record date value and populate in end date of old record as above, please help on how to implement this .
I have 5 records as below
Code: Select all
Id Date End date
1234 2017-08-09 2017-08-10
1234 2017-08-10 2017-08-11
1234 2017-08-11 2017-08-12
1234 2017-08-12 2017-08-13
1234 2017-08-13 2099-12-31