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

[rcandeo]

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';

[#2]

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]

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 · Accepted solution]

I finally found a simple way:

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

[suniljain]

Dear Robson,

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