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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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