2 Replies Latest reply: May 9, 2017 4:48 AM by Guruprem Saginadham RSS

    Issue with using  date in where clause

    Guruprem Saginadham

      Hi ,

       

      I am loading data from QVD with the following syntax. The issue is ORDER_DATE fetching data even from 2006 inspite I kept a where clause to bring only from 2009-Oct-01. Kindly help

       

      LOAD

          ORD_HEADER_ID,

          ORDER_NUMBER,

          Date(ORDER_DATE) as ORDER_DATE,

          CUSTOMER_NO,

          SALES_PESON_ID,

          ORDER_TYPE_ID,

          NAME,

          CREATION_DATE,

          LAST_UPDATE_DATE

      FROM [lib://QVDs (bi_administrator)/SALES_ORDER_HEADER.QVD]

      (qvd)

      WHERE ORDER_DATE >= Num(Date(01-10-2009, 'DD-MM-YYYY'));