topic SAP Dates in QlikView https://community.qlik.com/t5/QlikView/SAP-Dates/m-p/783213#M277300 <HTML><HEAD></HEAD><BODY><P>I am trying to just select a Year from VBAK.&nbsp; I am using the following SQL select statement with no luck.&nbsp; Any ideas?</P><P>Thanks</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 14pt;">SQL</STRONG></SPAN><SPAN style="font-size: 14pt;"> Select * from VBAK where (AUART = 'ZRRC' or AUART = 'ZBPC' or AUART = 'ZRPS' or AUART = 'ZBCS') and year(GUEBG) = '$(vPYear)' </SPAN></P><P></P><P>GUEBG is in a yyyymmdd format.&nbsp; When I use the full date it works.&nbsp; The variable is 2014.</P></BODY></HTML> Wed, 28 Jan 2015 18:41:44 GMT tmumaw 2015-01-28T18:41:44Z SAP Dates https://community.qlik.com/t5/QlikView/SAP-Dates/m-p/783213#M277300 <HTML><HEAD></HEAD><BODY><P>I am trying to just select a Year from VBAK.&nbsp; I am using the following SQL select statement with no luck.&nbsp; Any ideas?</P><P>Thanks</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 14pt;">SQL</STRONG></SPAN><SPAN style="font-size: 14pt;"> Select * from VBAK where (AUART = 'ZRRC' or AUART = 'ZBPC' or AUART = 'ZRPS' or AUART = 'ZBCS') and year(GUEBG) = '$(vPYear)' </SPAN></P><P></P><P>GUEBG is in a yyyymmdd format.&nbsp; When I use the full date it works.&nbsp; The variable is 2014.</P></BODY></HTML> Wed, 28 Jan 2015 18:41:44 GMT https://community.qlik.com/t5/QlikView/SAP-Dates/m-p/783213#M277300 tmumaw 2015-01-28T18:41:44Z