Extracting latest date from multiple column

[Ekta]

Hi Frnds ,  

Please help me with the formula to extract the latest date per id .

I am attaching below the input i am having and the required output for this.

eg-   Input

ID    date 1                date 2

1     13/02/2018

2     13/02/2018       12/02/2018

2     14/02/2018

3     13/02/2018       13/02/2018

3     14/02/2018       13/02/2018

3     15/02/2018       18/02/2018  

3     13/02/2018       13/02/2018

output

ID    date 1               

1     13/02/2018

2     14/02/2018

3     18/02/2018  

please help  me with this.

thanks in advance 

[jasperlch · Accepted solution]

Hi @Ekta,

You will first need a Transpose tool with ID as Key Fields and date1 and date2 as Data Fields. Then you will need a Summarize tool with ID as GroupBy and Value as Max.

Thanks,

Jasper

[Ekta]

Thank you so much, worked perfectly fine :)