Pick the record with most recent date

[Brad1]

How do I pick a record with most recent date?

Acct Number      Date

1                         2019/01/01

1                         2018/06/15

2                         2016/09/14

2                         2018/05/07

3                         1999/02/01

3                         2003/01/17

I'm thinking multi row formula tool but I'm not sure how to put it together.

[LordNeilLord · Accepted solution]

Hey @Brad1 

You could convert the date using DateTimeParse, then sort by Acct Number (asc) and Date (desc) then use the Sample tool to take top 1 record (grouping by Acct Number) 

[kelsey_kincaid · Accepted solution]

I created an example flow for you and attached it below. You'll want to sort and then use the sample tool, grouping by account number.

[Brad1]

Nice.  Thx.  Although I didn't use the Date Parse tool.  Seems to work just fine w/o it.

[jnans]

I had been thinking the same thing as the first person.