Hi All,
I have a QVW which will generate QVD on weekly basis.
now i need to change the master calendar to generate the QVd in Monthly basis. This is the master calendar we are using
LET tableloadStartTime=0;
SET vTotalRecordCount = 0;
Let NoOfDaysShift =0;
LET tableloadStartTime=Now(1);
if(WeekDay(today())<> 'Sat') and (WeekDay(today())<> 'Sun') Then
let NoOfDaysShift= num(WeekDay(today())*-1)-1;
ENDIF
IF (WeekDay(today())= 'Sun') Then
let NoOfDaysShift= -1;
ENDIF
let vExecDate = date(today()+$(NoOfDaysShift),'MM/DD/YYYY') ;
trace The date of execution is : $(vExecDate);
Let vToday = Today(1); // Custom Run
Let vToday_Num = num(floor(today(1)+$(NoOfDaysShift)));
According to this code QVW will run on Every Sunday in a week.
As per the First QVW which i have attached..
I need to run the QVW in Every sunday in a month ,
after the month end i need to show all the 4 or 5 weeks QVD data whcih is append to every week
if i run the QVW in any day in a month it has to generate the QVD.
Ex: if i run today it will load the QVD based on previous week sunday(i.e 26-4-2014)
like that after month end we need to show all the weekly data in month ..
