topic How to get date correct in QlikView

How to get date correct

Wed, 15 Jan 2014 15:28:22 GMT

Hi,

When I am loading data from ODBC drive i,e from access database it is showing data type mismatch error

the query is

Load a,b,c

select SQL * from Table where Date>'09/01/2012';

Can anyone help me as I tried in many date formats but nothing works for me please help me as this is urgent now please.

Thanks.

Wed, 15 Jan 2014 15:32:49 GMT

Hi Amelia,

Try this:

Load a,b,c

select SQL * from Table where Date>#09/01/2012#;

The # is delimiter for date in access.

Wed, 15 Jan 2014 15:40:47 GMT

Thanks and that works perfect