data investigation

[bh1789]

2022-07-01

2023-08-01

2022-06-01

2024-06-01

2024-07-01

2024-08-01

How would I filter data to only keep data with the most recent date of 2024-08-01?  The data is coming through as a "date" type

Thank you!

[alexnajm · Accepted solution]

Summarize to find the MAX of Date, and use a Join after to the original data to find those where the Date matches the Max_Date

Data -------------------------> Join ----->

   |                                                      |

   |-----> Summarize ------> |

[cjaneczko]

You can use a Summarize tool with it set to the Max Date.