How to retreive newest file from a directory

Question

I am looking for a newest file from the directory.

Directory : C:\Documents\Files

In the above directory there are multiple files like below.

123_test_data20220830abc.csv

234_test_data20220829abd.csv

345_test_data20220828bcd.csv

From the above files I need to retrieve the latest (today's file).

Can you please let me know how do we do that..?

Luke_C · Answer

You could use a dynamic input tool or batch macro to do that. There's lots of documentation on that in the community, but if you provide a sample file I could mock it up.

TysonSri · Answer

Thank you solution.

I want to populate data from latest file

Using sorting option i managed to get latest file  now how to populate/import  data from the  latest file as output

Thank you

Luke_C · Answer

Hi @TysonSri

Are you able to rely on any of the date time fields the directory tool outputs? If so, just sort the files based on the relevant field and use a sample tool to take the first record.