You can Create Variable like this.
let vCYCM = year(today())&if(len(num(Month(today())))=1,0&num(Month(today())),num(Month(today())));
where date = current month
Store Sales into Sales_$(vCYCM).qvd(qvd);
O/P you will get is Sales_201409.qvd;
It will change dynamically for each month.
when we are extracting from database then we are using this code i have already using same process for getting data. But here my question is one of my folder i have all months qvds like Sales_201408, Sales_201409, Sales_201410....So on. In this case i need to extract only current month data(Sales_201409) again next month i need to extract next month data(Sales_201410) by using dynamic code for each month.
This is the Question Could you please help me if any required please ping me.
Thanks & Regards
Create variables for Previous, Current, Next Months and use them while loading....
Let vPreMonthYear = Date(MonthStart(Today(),-1),'YYYYMM');
Let vCurMonthYear = Date(MonthStart(Today()),'YYYYMM');
Let vNextMonthYear = Date(MonthStart(Today(),1),'YYYYMM');
(ooxml, embedded labels, table is Sheet1);
Same way you can get previous month sales and next month sale (???)