2 Replies Latest reply: Nov 8, 2011 11:05 AM by Deepak Vadithala RSS

    Where clause using a date field

      Hi All,

      I’m trying to get the where clause in the script below to work. The CANCEL_DATE field will either have a value or be empty; I’m trying to load all the records where the CANCEL_DATE field is empty. Anybody knows to convert a date field to a number field?

       

      LOAD

      CANCEL_DATE,

      ORD_Number,

      ORD_REVENUE as TOTAL_ORDER_REV

      Resident Data

      Where num(CANCEL_DATE, '0.0' )= 0 ;