Hi all,
I'm trying to compare nine different date fields (I know) from one data set, and pull only the most-current date into a new column, MostRecentDate. My first thought was to do a series of if statements, if Date1 > Dates 2-9, and so on. Is there a faster way to get this answer, rather than brute-forcing it with if/elseif statements?
Current data:
| Name | Date1 | Date2 | Date3 | Date4 | Date5 | Date6 | Date7 | Date8 | Date9 |
| John Doe | 2016-04-25 | 2019-01-02 | [Null] | 2017-05-08 | 2017-08-23 | 2018-03-04 | 2018-11-07 | [Null] | [Null] |
| Jane Smith | 2016-03-24 | [Null] | 2018-12-25 | [Null] | [Null] | [Null] | [Null] | 2017-12-12 | 2017-12-27 |
Goal:
| Name | MostRecentDate |
| John Doe | 2019-01-02 |
| Jane Smith | 2018-12-25 |
