briangriffin
Programmer
Dataset looks like this:
I need the first order only, plus the order date of the next order, and discard the other records:
I've been all over with this, but can't quite get it. Any help is greatly appreciated.
Code:
Account OrderDate
100 5/1/2020
100 5/5/2020
100 6/1/2020
200 6/1/2020
200 6/2/2020
200 6/7/2020
I need the first order only, plus the order date of the next order, and discard the other records:
Code:
Account OrderDate NextOrderDate
100 5/1/2020 5/5/2020
200 6/1/2020 6/2/2020
I've been all over with this, but can't quite get it. Any help is greatly appreciated.