Naming Qvd automatically

[#1]

I am having the data which which comes out everything and i should name it according to the month wise

for example in the month of feb i will get jan data and it happens every month and i wanted to make qvd's for these monthly and store them

for this I am using

Let vPrevMonth =PICK((Month(Today())-1),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');

store PastMonth into $(QVD)\vPrevMonth.qvd(qvd);

but it is not working

[Gysbert_Wassenaar · Accepted solution]

Try dollar expanding your vPrevMonth variable too:

store PastMonth into $(QVD)\$(vPrevMonth).qvd(qvd);

[#3]

I am getting the month but also i need year also to be shown as Jan 2013

[#4]

try

vYear = year(Today());

store PastMonth into $(QVD)\$(vPrevMonth&vYear).qvd(qvd);

by Rebeca

[#5]

i want it to show Jan_2013.qvd

can you guide me on this one