Date format error

[dhavalvyas]

HI I am applying incremental load in one of application. While I am concatenate qvd with database table it shows following error.

Date format error. Database date format and qlikview date format does not matches.

As database date is in number format I convert qlikview date also in number format how ever it is still showing error.

Can anyone suggest correct way to do solve this issue?

[dhavalvyas]

My date format issue is resolved but it is showing that sql command not properly ended.

my script is like this,

load * ;

sql select

from table name

where date > variable;

[avinashelite]

Who you defined the variable ?? give the complete script