Load last version of Excel files

[#1]

Hi all,
I have to load only the last revision of excel files in a directory. They are named like:

DATA-20090325.XLS, DATA-20090331.XLS, DATA-20090430.XLS, DATA-20090430-1, DATA-20090430-2.XLS

In the example I have to load only the newest revision (if there are) of the last day of month (in bold font).
At the moment i have created a script that create a table with this data

DATA | MONTH | FILENAME | VERSION

20090325,MARCH,DATA-20090325.XLS,0
20090331,MARCH,DATA-20090331.XLS,0 <-
20090430,APRIL,DATA-20090430.XLS,0
20090430,APRIL,DATA-20090430-1.XLS,1
20090430,APRIL,DATA-20090430-2.XLS,2 <-

But I can't load ONLY the latest version of the last "elaborate-day" in every month. (They have an arrow in example above)
Any suggestion? Many Thanks!

[Oleg_Troyansky]

If you already have a table like this, you can use function "FirstSortedValue" to get the first existing date (sorted decending) and then only load those xls files.