topic How to make a date selection using Qlik View Connector for SAP? in QlikView

How to make a date selection using Qlik View Connector for SAP?

rcandeo — Tue, 07 Sep 2010 15:42:31 GMT

i am using Qlik View Connector for SAP and in my selection I need to use a date field, but it doesn't work.

Anybody can help me to find out how is the real format to make a selection within a date field?

I am trying like this:

SQL Select VBELN, AEDAT from VBAP

WHERE AEDAT = '07/09/2010';

Tue, 07 Sep 2010 16:34:49 GMT

Hi robson,

You can define a Variable at the Starting in Main like this:

Let vMinDate = num('01.01.2009')

and then

write a load like this


VBAP:
SQL Select VBELN,
AEDAT
.....
.....
From VBAP
where num(AEDAT) >= $(vMinDate)
;

Hope this helps.

Regards
Sravan

rcandeo — Tue, 07 Sep 2010 18:32:38 GMT

Unfortunatelly not worked.

It gave to me an SQL error:

Let vMinDate = num('01.01.2010');

SQL Select * from VBAP WHERE num(AEDAT) >= $(vMinDate);

rcandeo — Tue, 07 Sep 2010 20:05:32 GMT

I finally found a simple way:

SQL Select * from VBAP WHERE AEDAT = '20100907';

suniljain — Thu, 09 Sep 2010 13:41:11 GMT

Dear Robson,

I am Using same format like '20100907'. And it Works Fine