1 Reply Latest reply: Jul 11, 2018 11:40 AM by Francesco Reggiani RSS

    QVD WHERE clause?

    Ian Lapid

      I cant seem to get this to work?

       

      LET v_Load_Before_date = Date#('2018-07-02');

       

      temp_shift_duration:

      LOAD

          batch_id,

          shift_date

      FROM [$(vLibPath)$(vQVD_Name).qvd](qvd)

      WHERE shift_date < $(v_Load_Before_date);

       

      I suspect this: shift_date < $(v_Load_Before_date), doesn't really work?

       

      Thank you in advance!