This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
You could first transpose your data so all the date columns are pivoted to rows, then you can sort on the date column, keep the most recent date and then join this set back to your original data set. In Transpose tool, you can keep 'Dynamic or Unknown Fields' option checked so any new dates coming in will be included. Attached is a sample.