Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a problem when I want to limit qvd to concatenate into one qvd. For example I have 5 QVD history (Table_Jan2012, Table_Feb2012, Table_Mar2012, Table_Apr2012, Table_May2012). Every table created in the last days of month.
We all know, we can use wildcard (*) if we want to load all QVD directly (Table_*.qvd) and concatenateed into one qvd..
But in this case I want to load only last 3 QVD history automatically (Table_Mar2012, Table_Apr2012, Table_May2012), and save it into one qvd. And next month the script load only Table_Apr2012, Table_May2012, and Table_Jun2012;
Anyone know how to make it?
Thanks before.
Regards,
Heri
Maybe have a look at the addmonth function
Let vTodayMinusThree = addmonths('$(vMaxDate)',-3);
thanks brianm for your respon,
I dont think its can solve my problem, because the QVDs name is in string format.
Table_Mar2012 --- Mar2012 is string format..
regards,
Heri
You could possibly try renaming the QVDs
Then try using the date function