Hey guys,
I am trying to the following:
logold:
LOAD
max(date_exec) as maxdate
FROM [lib://QVD (multifood_mcunha) (qlik_qlik_service)/Log.qvd]
(qvd)
where sp_nome='SP_Budget_to_qlik';
let v_MaxDate = peek('maxdate');
Lognovo:
Load
sp_nome,
date_exec;
SQL EXEC SP_Log_Qlik;
let v_MaxDateNovo=peek('date_exec');
if(($(vMaxDate)=$(v_MaxDateNovo))) then
Exit;
else
STORE Lognovo into [lib://QVD (multifood_mcunha) (qlik_qlik_service)/Log.qvd](qvd);
Drop table Lognovo;
drop table logantigo;
endif;
but i get the following error:
![](/legacyfs/online/216741_pastedImage_8.png)
the date field format is yyyy-mm-dd hh:mm:ss
can you help me?
Best regards,
Miguel Cunha