Change end date

[Istwineres]

Hi all! 

I have this input file: 

             col1   col2       col3            col4           col5

row1  MAN 0QQ31                     0,36000 2020-07-02
row2  MAN 0QQ31 01-07-2020 0,36000 2020-07-01
row3  MAN 0QQ31 04-06-2020 0,36000 2020-06-04
row4  MAN 0QQ31 07-04-2020 0,36000 2020-04-07

row5  MAN 0A28TY6                     0,90000 2020-07-02
row6  MAN 0A28TY6 01-07-2020 0,90000 2020-07-01

I want to change for the last data into col2 the col5 into a fake date (eg. 01/01/1999). So row4/col5 should be 01/01/1999 and row6/col5 should be 01/01/1999.

Many thanks

[Jean-Balteryx]

@Istwineres , does it solve your problem ?

[Istwineres]

No, because it couldn't handle a single record case. I used my solution: a Multi-Row Formula where Iused this expression datetimeadd([Row+1:DateTime_Out],1,"days") and grouped by col1 and col2 then update the col5, respectively

[Jean-Balteryx]

I'm glad you solved it !