Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

SAP Dates

I am trying to just select a Year from VBAK.  I am using the following SQL select statement with no luck.  Any ideas?

Thanks

SQL Select * from VBAK where (AUART = 'ZRRC' or AUART = 'ZBPC' or AUART = 'ZRPS' or AUART = 'ZBCS') and year(GUEBG) = '$(vPYear)'

GUEBG is in a yyyymmdd format.  When I use the full date it works.  The variable is 2014.

0 Replies