filter dynamic dates

Question

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 · Answer

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

ers_rcia · Answer

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 · Answer

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.