calender

[#1]

how to create calender for including next year....

My code is :

LET vTodaysDate = num(Today());

LET vStartDate = num(AddMonths(YearStart($(vTodaysDate)),  -4 * 12));

LET vEndDate = num(YearEnd($(vTodaysDate)));

LET NumberOfDays = num(YearEnd($(vTodaysDate))) - $(vStartDate) + 1;

Date:

LOAD Max(Date) AS Date

FROM

$(STAGE1_TRANSACTION_DATE_QVD_PATH)Date_DAILYSALES.qvd

(qvd);

LET vDate=Floor(Num(Peek('Date',0,Date)));

Drop Table Date;

please reply soon...

[nagaiank · Accepted solution]

You may use the calendar end date defined by

LET vEndDate = num(AddMonths(YearEnd($(vTodaysDate)), 12));

[senpradip007]

You can use like

Date:

LOAD Min(Date) AS MinDate,

FROM

$(STAGE1_TRANSACTION_DATE_QVD_PATH)Date_DAILYSALES.qvd

(qvd);

LET vMaxDate=AddMonth(Today(), 12);

LET vMinDate=Peek('MinDate',0,Date);

Drop Table Date;