Storing a QVD in dynamic name

[#1]

Hi i want to store a qvd in dynamic name and i tried as follows

Store tab into day(today())&.qvd

Store tab into table&day(today())&.qvd

Store tab into tab&$(day(today())&.qvd

Store tab into tab&$(var1)&.qvd where variable var1=day(today()

But nothing is working. How can i store a qvd in dynamic name. Kindly help me....

[Miguel_Angel_Baeyens]

Hello Dora,

Whether you are in a loop while creating the file name or not, I'd as follows:

LET vToday = Today();STORE TableName INTO $(vToday).QVD

This should work.

Regards.

[#3 · Accepted solution]

I do something like this:

Let vFromDate=num(MonthStart(addmonths(now(), -13)));
Let vToDate = num(floor(now(),1)) - 4;

do while vFromDate < vToDate
// logic
Let QVDFileName = '..\qvd\Data' & '-' & date(vFromDate, 'YYYY-MMM-D') & '.qvd';
store Data into $(QVDFileName );
Drop table Data;
Let vFromDate = vFromDate + 1;
loop