follow same for year & qtr
LET vcurrentdate= num(MonthStart(AddYears(num(Today()),-3))); // Set start date
DO WHILE vcurrentdate <= Today()
ExportSales:
NOCONCATENATE
LOAD *
RESIDENT Sales
WHERE InMonth(Date, $(vcurrentdate), 0) = true();
LET vdatestring = Date($(vcurrentdate), 'YYYY_MMM');
// STORE Sales INTO (qvd); // Your export file name
STORE ExportSales INTO [.\$(vdatestring).QVD] (qvd); // Mine
DROP Table ExportSales;
LET vcurrentdate = num(AddMonths($(vcurrentdate), 1));
LOOP
