filter dynamic dates

[ers_rcia]

Hi guys, need help with date filter. I need to filter the last 2 highest date, (taking only 01-04 and the two 01-03 dates from this pic.). The dates due change and the number of duplicate dates that i need to get. Any help would be greatly appreciated. Thanks!

[daryllj]

Hi, you can filter the first two 'latest' dates using the tools below. You can use the "Join" tool to further filter the data if you only need the data with the given dates.

 

[ers_rcia]

Hi daryllj, the result only showed 2 dates, i also need to get ID 5 because it has the same date with ID 3

[daryllj]

I see... I believe this is what you're looking for? Add in the Summarize tool the "Max" action for "ID".