This content has been marked as final. Show 2 replies
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'));
SELECT MAX(Data) as Dstx FROM time_dimension;
LOAD floor(date(Dstx ,'DD/MM/YYYY'))
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 ?