MaxDate Error

[rammuthiah]

I tried loading files using max date.

But error occurs while using where condition.

Table:

Load

ID,

trim(num(date(date#(subfield(Subfield(FileName(),'Incident ',2),'.',1),'DD-MMM-YY'),'DD/MM/YYYY'))) as File

From Excel

MaxDate:
Load
max(trim(num(File))) as MDate

Resident Table;

let Vmaxdate=Peek('MDate',0,'MaxDate');

NoConcatenate
Data:
Load *

Resident Log
where num(File)= num($(vMaxFileDate))                     //Unexpected token error occurs while loading using where condition
;

[Taoufiq_Zarra]

the error is in the load?

the variable is Vmaxdate and in where you use vMaxFileDate ?

let Vmaxdate=Peek('MDate',0,'MaxDate');

NoConcatenate
Data:
Load *

Resident Log
where num(File)= num($(vMaxFileDate)) //Unexpected token error occurs while loading using where condition
;

[rammuthiah]

Error is in the load. not in the UI.

where num(File)= num($(vMaxFileDate))     //Unexpected Token error

[Taoufiq_Zarra]

if i understood

where num(File)= num($(Vmaxdate) instead of where num(File)= num($(vMaxFileDate))

[rammuthiah]

Ah!!! My mistake. It's working now. Many Thanks