Hi,
I have this in data, I am going to use this in a interval match, but the problem is, I want that if the last record Color is yellow there should be a new Start date based on the Start date in the last row! and set the End date as todays date.
Se example
Current data, wished outcome in (Red)
Name | Start | End | Color | Group |
Thomas | 2012-05-29 | 2013-11-07 | Green | 5 |
Thomas | 2011-06-08 | 2012-05-29 | Yellow | 3 |
Thomas | 2015-05-08 | 2016-07-05 | Yellow | 6 |
Thomas | 2016-07-05 | Date(Today) | Yellow | 6 |