topic Incremental Load Date format issue in QlikView

Incremental Load Date format issue

brijesh1991 — Thu, 16 Jan 2014 04:46:28 GMT

I had incremental date: Last Update Date in M/DD/YYYY hh:mm:ss TT format.

Example: 8/11/2009 10:37:00 AM

While taking incremental Load;

Load * from table where [Last Update Date] >= $(vThisExeTime) and [Last Update Date] <=$(vLastExeTime)

where vThisExeTime= chr(39) & Date(now(), 'M/DD/YYYY hh:mm:ss TT') & chr(39)

and the same is storing at end of the entire script into vLastExeTime.

But I am getting error: Attached image

Re: Incremental Load Date format issue

tresB — Thu, 16 Jan 2014 04:50:33 GMT

Try putting single quotes around variable expansion, like: ' $(vThisExeTime)'

Edit: you might have to redefine your variable excluding chr(39)

Re: Incremental Load Date format issue

nilesh_gangurde — Thu, 16 Jan 2014 05:09:57 GMT

See this link, this will help you.

Incremental Load Help??

-Nilesh

Re: Incremental Load Date format issue

brijesh1991 — Thu, 16 Jan 2014 05:12:07 GMT

Thanks TRESESCO for your idea... but unfortunately not working!

Re: Incremental Load Date format issue

rwunderlich — Thu, 16 Jan 2014 05:21:45 GMT

I haven't worked with Sybase, but from the doc it appears timestamps should be of the ISO 8601 standard format of YYYY-MM-DD hh:mm:ss. So try presenting your SQL WHERE arguments in that format.

-Rob

Re: Incremental Load Date format issue

tresB — Thu, 16 Jan 2014 05:32:38 GMT

Possibly a format mismatch. Please be doubly sure of it; check little things like, if any space difference, or so.

Re: Incremental Load Date format issue

brijesh1991 — Thu, 16 Jan 2014 05:35:47 GMT

Hi Rob,

you are wonderful, even if you haven't worked on sybase, your idea worked. . .!

Thanks brother!!! Thanks!