sql data in variable

[#1]

Hi everyone !

I need to bring one value (date) from sql server to  a variable in qlikview and after make a tratative this of data  , the problem is that variable always stay null.

follow part of the code

LET MinDate = floor(date(VStartAno, 'DD/MM/YYYY'));

cld_temp:

SQL

  SELECT MAX(Data) as Dstx FROM time_dimension;

xtemp:

LOAD  floor(date(Dstx ,'DD/MM/YYYY'))

Resident  cld_temp;

LET MaxDate = Dstx;

DROP TABLE cld_temp;

DROP TABLE xtemp;

the maxdate stay null, and would should to stay like 41630.

someboy have some idea ?

[Gysbert_Wassenaar · Accepted solution]

Try using the peek function:

LET MinDate = floor(date(VStartAno, 'DD/MM/YYYY'));

cld_temp:
SQL SELECT MAX(Data) as Dstx FROM time_dimension;

LET MaxDate = peek('Dstx');

drop table cld_temp;

[#3]

worked, thanks!!