Qlik Sense- compare timestamps

Anonymous — Thu, 25 Oct 2018 10:40:20 GMT

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:

the date field format is yyyy-mm-dd hh:mm:ss

can you help me?

Best regards,

Miguel Cunha

topic Qlik Sense- compare timestamps in App Development