Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am using the below to store my qvd in current month name but i want to store the current month qvd in next month name.
LOAD LOAN_AC_NO,
NAME,
EMI_AMOUNT,
OVERDUE,
Month(LASTPROCESSDATE)&'_'&Year(LASTPROCESSDATE) as ReportingMonthYr
LASTPROCESSDATE;
[ODREPORT]:
SELECT "LOAN_AC_NO",
"NAME",
"EMI_AMOUNT",
"OVERDUE",
"LASTPROCESSDATE"
FROM "INT_USR"."ODREPORT";
MonthYear:
LOAD
ReportingMonthYr as MonthYear
Resident [ODREPORT];
LET vYearmonthstoreBounce = Peek('MonthYear');
STORE [ODREPORT] INTO [lib://TestQVDPATH /ODREPORT_Live_$(vYearmonthstoreBounce).QVD] (qvd);
Drop table [ODREPORT];
Drop table MonthYear;
Hi Joshua,
Try the addmonths function
G.
Hi Joshua,
Try the addmonths function
G.
Modify it with
LET vYearmonthstoreBounce = Addmonths(Peek('MonthYear'),1);
May be:
LET vYearmonthstoreBounce = Peek(MonthYear,1,'MonthYear');