10 Replies Latest reply: Jun 25, 2014 10:43 AM by Jan Heinrichsdorff RSS

    Where statement

      Hello experts

       

      I would like to exclude values in a field that are in the future using a where statement:

       

      SQL SELECT "auf_datum",

          bez as Leistungstext,

          jobnr,

          "auf_anzahl",

          ltyp,

          storniert,

          optional,

          verkauf_soll as VK_soll,

          verkauf_ist as VK_ist,

          einkauf_ist as EK_ist,

          auf_brutto as EK_soll,

          jznr,

          lartnr 

      FROM EASY.jleistg where storniert = 0 and optional = 0 and "auf_datum" < (here I would like to load the actual date);

       

      Does anyone know how to read the date in there?

       

      Thank you for your help!