I need Where Max CreateDate

[Sxbbb]

I need Where Max Filed ' CreateDate'

[Aditya_Chitale]

MaxDate:
Load
max(CreateDate) as MaxCreateDate
From [xyz.qvd](qvd);

let vMaxCReateDate=peek('MaxCreateDate',0,'MaxDate');
Drop table MaxDate;

MainTable:
load
a,
b,
CreateDate,
d,
e
From [xyz.qvd](qvd) where CreateDate='$(vMaxCReateDate)';

Regards,

Aditya

[Sxbbb]

I tried but the data is not showing.

[Aditya_Chitale]

Check if the field date format is same as date format in variable.

If that doesn't work ,please share sample data ?  You can jumble the numbers if you want.

Regards,

Aditya