Load files with datenames

[Anonymous]

Hi,

I want to load numerous files that have dates in their names. And i want to load all files execpt the one with todays date.

So a few examples:

Load *

From File_2011-09-01.qvd

(Will load that specific file)

Load *

From File_*.qvd

(Will load all files)

I dont know how to write the variable that's going to narrow my filename so eveyfile except todays will load.

Please help.

Thanks!

[martinpohl · Accepted solution]

Hello,

you can do it like this:

Load * from File_*.qvd (qvd) where filebasename() <> 'File_'&today();

Maybe you have to edit the today-date-format.&date(today(),'YYYY-MM-DD').

Regards

[Anonymous]

Thanks alot!