Most Recently Created File Filtering With Directory and Dynamic Input Tools

[MarshallG]

Hi All-

Is there a way to use the Directory and Filter tools to select a Directory, look through the files, and then filter to only the most recently created file based on the file metadata.

My example below allows me to filter on the files that were created after 11/01/2015, but I want to access just the newest file.

[RodL]

Try using this expression...

[FullPath] + "|" + Replace([FileName], "zip", "csv")

The FullPath has the .zip file specified...the name after the pipe needs to have the .csv extension. (It's looking "inside" the .zip file for the real file name.)

Also, you don't need the second pipe in the expression like you appear to have.

What you want the FullPath string to look like is...

"C:\FileName.zip|FileName.csv"

[rmwillis1973]

I still can't get it to work.  Working is in attachment.

I created a folder called Data which contained 2 zipped csv files:

Email2016-11-06.csv and

Email2016-10-30.csv

[RodL]

@rmwillis1973,

I posted a response to your new post that you added.