Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi All
some one help me to find error
Temp1_Max_Date:
load max([Date Identifier]) as [Max Business Date] resident Date;
let vMaxDate= Date(peek('Max Business Date '),'DD-MM-YYYY');
Temp2_Date;
load [Date Identifier] as [test date1] resident Date where [Date identifier]='$(vMaxDate)';
LET vdate1=peek('text date');
Thanks in advance
rohith
Hi,
may be like this
Temp1_Max_Date:
load max(date(date#([Date Identifier],'DD-MM-YYYY'),'DD-MMM-YYYY')) as [Max Business Date] resident Date;
let vMaxDate= Date(peek('Max Business Date',0,'Temp1_Max_Date'),'DD-MM-YYYY');
try this
Temp1_Max_Date:
load max([Date Identifier]) as [Max Business Date] resident Date;
let vMaxDate= peek('[Max Business Date]',0,'Temp1_Max_Date');
Temp2_Date:
load [Date Identifier] as [test date1] resident Date where [Date identifier]='$(vMaxDate)';