3 Replies Latest reply: Aug 3, 2014 5:22 AM by UPALI WIJERATNE RSS

    date condition in script

    UPALI WIJERATNE

      Hi Friends

       

      LOAD

       

            DATE(POL_PERIOD_FROM) AS POL_PERIOD_FROM ,

            DATE(POL_PERIOD_TO) AS POL_PERIOD_TO , 

           INT_MODE,

           INT_CLASS_CODE,

         AMOUNT

          

      FROM

      SS_Claim.qvd

      (qvd)

      WHERE POL_PERIOD_TO BETWEEN '01-JAN-2014' AND '30-JUN-2014';

       

      in my above script the condition highlighted in red does not work. What may be the correct script. Pls help me