How to change the code

[#1]

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 ..

[#2]

please help me ... i need it immediately

[its_anandrjs]

You can use task schedular for QVD making and triggered the QVD makers on particular date of month and also there is many options for the QVD makers.