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';
You can define a Variable at the Starting in Main like this:
Let vMinDate = num('01.01.2009')
write a load like this
VBAP:SQL Select VBELN,AEDAT..........From VBAPwhere num(AEDAT) >= $(vMinDate);
Hope this helps.
Unfortunatelly not worked.
It gave to me an SQL error:
Let vMinDate = num('01.01.2010');
SQL Select * from VBAP WHERE num(AEDAT) >= $(vMinDate);
I finally found a simple way:
SQL Select * from VBAP WHERE AEDAT = '20100907';
I am Using same format like '20100907'. And it Works Fine
Retrieving data ...