Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Folder with Variable Name

Hi

I often use variables when I store files as qvd and it works fine.

For exemple:

Let now = left (today(),7);

store field1 from table1 into Folder\Filename$(now).qvd (qvd);

But, how do you create a new folder/directory with a variable name defined as say, today's date, in the store into statment?

This won't work for me:

Let now = left (today(),7)

store field1 from table1 into Folder\$(now)\Filename.qvd (qvd);

Any ideas?

/Kristofer

1 Reply
Not applicable
Author

Hi,

try

LET now=LEFT(NOW(),7);
let path='c:\';

Let cmd='cmd.exe /c md $(path)$(now)';

EXECUTE $(cmd) ;

Assume that should match your needs.

Best regards

Michael