Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

Greater than timestamp and date condition check not working in qlik sense script

Hi

In load script i have to load greater than lastly loaded date and between three days.

I tried with many cases but not working

Load * where

Num(timestamp ($(exe_dt)))> Num(timestamp ($(last_exe_dt))) and dt<=$(max_dt) and dt>=$(min_dt);Sql  select Statement;

$(Max_dt) is today() date;$(Min_dt) is today()-3

Please help to solve this i tried by giving mostly all possible timestamp and date formats.

Labels (1)
0 Replies