load script date format error

[Anonymous]

Hello

I am trying to load below "load script"

but i get the following error

the date format at sql is '2018-01-01 00:00:00:000'.

can someone help with this error. What should i do?

My aim is to load only the updated rows from the sql server to qvd file.

[arvind1494]

first try

where datetime > '2018-01-01'

and let me know if it works then I will provide you better  suggestion

Note:

Qlik consider date as a number

but in sql date is separate data type

[agigliotti]

let's try using the below syntax:

Where DateTime > Date( $(Last_Update_time), $(TimestampFormat) );

I hope it helps.

[Anonymous]

same error here

[arulsettu]

maybe like this

where datetime > date '2018-01-01'

[Anonymous]

This is the result.

[Anonymous]

no luck.

[agigliotti]

how your timestamp environment variable looks like ?

ex.

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

it should match your sql date format.

[arulsettu]

to match sql with the timestamp

where datetime > date '2018-01-01 00:00:00:000'

[Quy_Nguyen]

Should be like this:

Where DateTime > Date( $(Last_Update_time), '$(TimestampFormat) ');