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

    Where clause with date issue in Loading

    Supriya R

      Hi,

       

      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`,

           `campaign_group_id`,

           `start_date`,

            expiration_date;

      SQL SELECT `campaign_id`,

           `start_date`,

           `campaign_group_id`,

            expiration_date,

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

       

      what am i missing?