Incremental load date issue

[Rajesh]

Hi All,

I am trying to do incremental load with opened_at (Date field) in source it is like (opened_at = '2017-08-02 11:30:45.0000000').

after i doing max(opened_at) as Maxopendate; it is showing like 42949.778564819.

Please see below error i am facing while trying to only newly inserted data with usong opened_at date field,

Can any one suggest.

Thanks,

Rajesh

[Chanty4u]

did you tried to convert that into proper date format and do it

[kaushiknsolanki · Accepted solution]

Hi,

Try converting it into a timestamp like below.

Let vDate = Timestamp(peek('Max',0','Max'),'YYYY-MM-DD hh:mm:ss');

Regards,

Kaushik Solanki

[tresesco]

Format your variable like:

Let vTime=Timestamp(Peek('Maxopendate'), 'YYYY-MM-DD hh:mm:ss.fffffff')

[gsbeaton]

You are mixing date formats.  You will have to convert the Qlik timestamp to match the source table time format.

Something like this: date(opened_at,'DD/MM/YYYY hh:mm:ss[.fff]')

Hope this helps.

George

[Rajesh]

Thanks Kaushik,

but it showing error like below

[kaushiknsolanki]

Hi,

Your variable should be in single quote

Where Field = '$(vVariable)';

Regards,

Kaushik Solanki

[tresesco]

Try putting single quotes around variable like:

...

     where opened_at > '$(YourVariable)' ;

[Rajesh]

its done now

Thank u much Kaushik.

Regards

Rajesh