2 Replies Latest reply: Oct 3, 2017 7:52 AM by Hakan Ronningberg RSS

    Where clause with Date comparison in SAP Connector

    Michele De Nardi

      Hi expert,

      i'm using Qlik Sap connector to extract some data and want to extract all the record that AEDAT is major than yesterday.

      I have already tried to this solution

       

      SQL SELECT *

      FROM  TABLE

      WHERE AEDAT >= 20171001;


      and also


      SQL SELECT *

      FROM  TABLE

      WHERE AEDAT >= '20171001';


      and also


      SQL SELECT *

      FROM  TABLE

      WHERE AEDAT >= '01/10/2017';


      and also


      SQL SELECT *

      FROM  TABLE

      WHERE AEDAT >= 01/10/2017;


      but it doesn't work because AEDAT is stored with DD/MM/YYYY format and i don't know how to compare AEDAT with yesterday date in order to obtain all record with AEDAT >= yesterday.

       

      Any ides ?