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

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