not able put the date filter in where clause

[#1]

Hi Guys

When i am pulling the data from navision 4.0 into qlikview with date filter in the where Clause ...

i am getting the following error :

SQL##f - SqlState: 22008, ErrorCode: 0, ErrorMsg: [Simba][SimbaEngine ODBC Driver]Invalid date, time or timestamp value.

Return_Receipt_Header:

[nilesh_gangurde]

OK

first find out the which date format is there in the database.

then implement the same formate in qlikview.

hope this will help.

-Nilesh

[Anonymous]

Hi Manish,

Please first of all check , are there null values available in you datefield in data base.

If yes then Please update that part with some fake date.

Or you can use OLEDB instead of ODBC.

This will resolve your problem.

Please try and confirm the output.

Regards

Nitin

[#4]

Hello Manish,

You can load all the data from your data source into Qlikview table and then use a where clause.

Temp:

Load *

from DataSource;

Result:

Load *

resident Temp

where date >= 01/01/2005;

drop table Temp;

Thanks,

Angad