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

Announcements
Qlik Unveils New Agentic Capabilities Across Analytics, Data Engineering, and Trust: 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.

Labels (1)
0 Replies