Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

How to get the max date from a set of files?

Hello!

I have a folder named Selections in C:\Users\Mic\Documents\Selections\ where I have files with this format:

File_DD_MM_YYYY_HH_MM_SS.csv

For example:

File_03_07_2012_17_25_30.csv

File_15_10_2012_12_40_25.csv

File_07_05_2013_08_15_43.csv

File_01_03_2014_11_18_12.csv

File_29_08_2013_09_30_27.csv

I need to read those filenames from the folder to get the file with the max date.

In this case, it'd be: File_01_03_2014_11_18_12.csv

Then I'd need to read it's content.

How could I do that?

Thank you!!!

10 Replies
microwin88x
Creator III
Creator III
Author

Hello Anand! Thanks for your answer! I'm going to check it and let you know if it worked for me