Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Incremental Loading Timestamp Error

Hi

I have tried formatting the timestamp in all the ways that are referred in the community. In simple words, I am tired of searching answer for my problem.

I want a query string which needs to look for the modified_date field for values greater than 2/8/2013 3:32:19 PM which is stored in $(LastExecTime) .

ANy help on this ??

Tags (1)
2 Replies
sivarajs
Valued Contributor II

Re: Incremental Loading Timestamp Error

Select * from table where modified_date>'$(LastExecTime)';

chauhans85
Esteemed Contributor

Re: Incremental Loading Timestamp Error

try to put it in sigle quotes

modified_date>'$(LastExecTime)'

hope this helps

Community Browser