Using peek in a variable.

[risabhroy_03]

I have a qvd named TWHUIL962.qvd and there is a field called ASDT which is called As on date

I have to create a variable to store the maximum value of ASDT (As on Date) using the peek function.

Kindly help me out.

[stevejoyce · Accepted solution]

if you want the max date in the file it would be like:

max_date:

load max(ASDT) as max_date

from <your table>

;

let vMaxDate = peek('max_date', 0, 'max_date');

drop table max_date;