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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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