Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Qlik Sense- compare timestamps

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

0 Replies