Select the last Date in the field into the Script

[Anonymous]

Hello,

I would like to assimilate to the named 'Last_Update_NBI' the last Date present into the field [AIR Import Data], so i did this into the script:

load Distinct [AIR Import Data] as LastAsOf

resident [FinalTable];

Let Last_Update_NBI = Date(Peek('LastAsOf'), 'DD/MM/YYYY');

But it return that:

Where 31/12/2015 is considered as the last value by QlikView 😕

I tried to use the MAX() function but it doen't work.

How can i do that please ?

Thanks you in advance for your help,

Sébastien.

[sunny_talwar]

Agreed, unless another type of format is desired using the Date() function it won't make a difference

[Anonymous]

Yes !

[sunny_talwar]

Great