Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
You may use the calendar end date defined by
LET vEndDate = num(AddMonths(YearEnd($(vTodaysDate)), 12));
You may use the calendar end date defined by
LET vEndDate = num(AddMonths(YearEnd($(vTodaysDate)), 12));
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;