Category "self-join"

Use date (-1 day) on next row to be the end date for current row

I am trying to self join in my current script in order to find the next row and then whatever day specified it should minus 1 day from it and put that in the e