Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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';
I finally found a simple way:
SQL Select * from VBAP WHERE AEDAT = '20100907';
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
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';
Dear Robson,
I am Using same format like '20100907'. And it Works Fine