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.