6 Replies Latest reply: Oct 16, 2014 5:45 AM by Fra Car RSS

    CALCULATED FIELD CREATION INTO QVD LOAD - WHAT'S WRONG IN THIS SYNTAX?

      LOAD 

      ...

      ...

      ScheduledDateTime

      IF (time(time#(ScheduledDateTime, 'dd/mm/yyyy hh:mm'), 'hh:mm') < '10:00', '1st wave', 'Normal') AS "First Wave",

      ...

      ...

      FROM xyz.qvd

       

      what's wrong with the syntax above? why can't I display the First Wave field?

      thanx