4 Replies Latest reply: Oct 19, 2017 9:55 AM by Eduardo DImperio RSS

    Help with Where

    Eduardo DImperio

      Hi ,

       

       

      For some reason my clause WHERE doesn't work.

       

       

      My code just ignore this clause as below

       

      Code

       

      vData=date(vData-dias);

       

      NoConcatenate

      Aux:

      LOAD

      OID_SYSTEM,

      DATE_READ,

      '$(vData)' AS TESTE

      RESIDENT RS_INDIVIDUAL_READ

      WHERE DATE_READ > FLOOR($(vData));

       

      DROP TABLE RS_INDIVIDUAL_READ;


      Output:


      where.JPG