A couple of observations. First up, another alternative to listing all source files or using a star is looping through each file in code. This allows you to add logic to decide whether you want to take the file or not. For example here I am loading from a folder of Excel files - but want to ignore the temp files created when a file is opened:
For each vFileName in filelist(vSourceFolder & vFileMask) if index(vFileName, '~$') = 0 then // ~$ denotes an open file temp file LOAD * FROM [$(vFileName)] (biff, no labels, table is RT$); end if next
The other observation is that parsing the filename of the QVD and using that as a date will work fine, but it will cause a non optimized QVD load. It will be much more efficient to write the date into the QVD file at time of creation (it's obviously known as it's in the file name). For more information on Optimized vs. Non Optimized search the community - but just to let you know it can be up to 100x quicker!