Filter to most recent date

[skeen503979]

Hello, 

When working with a file that updates daily, how can you create a filter to only select the "most recent date"?  I know how to select specific dates but with data that evolves how can I be sure I'm displaying the latest results?

Thanks

[messi007 · Accepted solution]

@skeen503979,

Have you tried to use group by Max date then filter on that date using join tool:

Attached the workflow,

Hoe this helps!

[atcodedog05]

Hi @skeen503979 

Here is how you can do it.

Workflow:

1. Find the latest date using summarize tool.

2. Using join tool to keep only max date rows.

Hope this helps : )

[Kamran1991]

Hi @skeen503979 

By using the attached workflow, you can filter all the records with current date.

Please let me know if it works for you.

[skeen503979]

Thank you, all.  @Kamran1991 @atcodedog05 @messi007 

[atcodedog05]

Happy to help : ) @skeen503979 

Cheers and have a nice day!