Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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