2 Replies Latest reply: Dec 14, 2012 1:49 PM by Adotey Kwame RSS

    Load table where date is between

    Adotey Kwame

      Hi,

       

      I was hoping to load with date between . i.e

       

      LOAD

      A

      B

      C

      FROM  dbs

       

      where Date(APPLIED_DATE,'yyyy/MM/dd') >= '2010/01/01'  and Date(APPLIED_DATE,'yyyy/MM/dd') <= '2012/31/01' ;

       

       

      Please help with the syntax. Thanks