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?

[its_anandrjs]

sample  data and script required to have a look.

[dhavalvyas]

OK I am sharing you an screen shot of error message.please do needfull.

[dhavalvyas]

Sorry I can not share any of screen shot but can you suggest any idea to resolve this issue ?

1> I am storing maximum date from qvd into variable.

2>Then loading data from database and concatenate it with above qvd.

3>At the end apply condition where date greater than(>) variable.

Both qvd date and database date are in same format i.e. in num,however it shows date format error.

please do needful as soon as possible.

[techvarun]

It looks like the data format in the variable and SQL table is Different.

Try converting to date format using date functions in qlikview and then load.

[CELAMBARASAN]

Its better atleast if you post the script here

Did you formatted QlikView Date format to the desired Database format, Could you please specify the database date format here?

Did you verified running the query directly against a database using some query explorer, with the hardcoded value in place QlikView variable?

[avinashelite]

Try to add a date formatting like this for all the places where your using the variables

Date(Expression/Variable,'DD-MM-YYYY')

note: change the format according to your required date format

[dhavalvyas]

OK I am trying it and inform you whether it is working or not.

[dhavalvyas]

It shows ORA OLEDB error and table or view does not exist.

[avinashelite]

I feel its issue at your DB end , try to hit the query directly at the DB end test once