help

[NavinReddy]

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

[Kushal_Chawda]

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');

[#3]

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)';