4 Replies Latest reply: Jan 7, 2013 8:07 PM by mhalvorson RSS

    Can you use a date variable in Edit Script?

      Hi

       

      I am trying to limit the number of records that I import in Edit Script by using a date variable.

       

      One table has one record with a date field which I want to use as the variable . The other table has the records.

       

       

      Table with date record:

       

      LOAD date,

          Module;

      SQL SELECT *

      FROM live where Module = 'db';

       

       

      The code with the variable is below:

       

      LOAD

          date,

          debtor,

          amt;

      SQL SELECT

            date,

            debtor,

            amt

      From debtor_table where date >= 'variable';

       

      Is it possible to link the variable to a value that is retrieved in earlier script from a different table?

      I notice that there are some system variable names for dates - can I use them as the variable instead?

       

      Regards