We have a query where we need the EndDate to be the StartDate of the previous entry for all particular values in a row

[shivareddysompa]

We have a query where we need the EndDate to be the StartDate of the previous entry for all particular values in a row

[to4kawa]

| autoregress StartDate as p_StartDate
| eval EndDate=if(EndDate!="",EndDate,p_StartDate)

[shivareddysompa]

i want like End date will be next Start date and also 

Startdate               Endate 

10-02-2019         07-07-2020

07-07-2020         "blank "

blank indicates it is running

[to4kawa]

your sample is too little.

please show the table what you want.