11 Replies Latest reply: Feb 22, 2017 7:39 AM by Supriya R RSS

    Where clause with date issue in Loading

    Supriya R



      I want to load data where expiration date is greater than today, when i load script it doesnt filter data above expiration date greater than today(). Below shows all data.


      in my databse i have date in this format 2015-02-11 23:59:59



      let varExpirationDate  = Timestamp(Today(),'MM-DD-YYYY hh:mm:ss');



      LOAD `campaign_id`,




      SQL SELECT `campaign_id`,




      FROM rcdb.CAMPAIGN where expiration_date >= '$(varExpirationDate)';


      what am i missing?