I tried to use timestamp as "rising column" but it didnt work.
when input type = Rising
After changing to Rising mode you have to execute query once. Then you should update your query with where clause. Most probably error reason is checkpoint "?" variable has no value yet.
If that does not work you can update checkpoint value with a valid time value from your results.