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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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