topic Re: Incremental Loading Timestamp Error in QlikView

Incremental Loading Timestamp Error

Wed, 20 Feb 2013 06:54:48 GMT

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 ??

Re: Incremental Loading Timestamp Error

sivarajs — Wed, 20 Feb 2013 06:57:37 GMT

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

Re: Incremental Loading Timestamp Error

SunilChauhan — Wed, 20 Feb 2013 06:58:37 GMT

try to put it in sigle quotes

modified_date>'$(LastExecTime)'

hope this helps