topic Re: Date format error in QlikView

Date format error

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Date format error

its_anandrjs — Mon, 09 Oct 2017 18:17:19 GMT

sample data and script required to have a look.

Re: Date format error

dhavalvyas — Tue, 10 Oct 2017 04:41:36 GMT

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

Re: Date format error

dhavalvyas — Wed, 11 Oct 2017 06:14:50 GMT

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.

Re: Date format error

techvarun — Wed, 11 Oct 2017 06:30:59 GMT

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.

Re: Date format error

CELAMBARASAN — Wed, 11 Oct 2017 06:32:59 GMT

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?

Re: Date format error

avinashelite — Wed, 11 Oct 2017 06:33:51 GMT

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

Re: Date format error

dhavalvyas — Wed, 11 Oct 2017 06:34:40 GMT

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

Re: Date format error

dhavalvyas — Wed, 11 Oct 2017 07:08:41 GMT

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

Re: Date format error

avinashelite — Wed, 11 Oct 2017 10:57:36 GMT

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

Re: Date format error

dhavalvyas — Wed, 11 Oct 2017 11:26:58 GMT

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;

Re: Date format error

avinashelite — Wed, 11 Oct 2017 11:36:58 GMT

Who you defined the variable ?? give the complete script