5 Replies Latest reply: Feb 6, 2012 10:07 PM by Ronald Calolot RSS

    Where clause with Date comparison in SAP Connector

      Hi,

      I'm trying to get rows from some SAP tables, depending on the date they've been created/modified.

       

      The "SQL" statement I'm trying to use looks like:

       

      CUSTOM CONNECT TO "Provider=QvSAPConnector.dll ...

       

      Load *;

       

      SQL SELECT *

      FROM  TABLE

      WHERE DateField = '2011/01/11';

       

       

      STORE  TABLE INTO  ANY.QVD;

       

       

      How can I define correctly my date definition for my where clause? I'm trying almost everything but it doesn't work.

       

      Thanks for your help in advance,

      Aitor.