0 Replies Latest reply: Sep 25, 2012 7:51 AM by sudeep dhoju RSS

    filtering data on date while fetching from SAP

    sudeep dhoju

      Hi,

       

      zicrm:

      load

      /bic/submiton,

      zcaldate,

      z_z4

       

      sql select  /bic/submiton,zcaldate,z_z4 from /bic/zicrm;

       

       

      In the above mentioned eg, i want to filter data on datefield i.e(/bic/submiton) for last two days including today,

      where /bic/submiton has data in text format e.g: 01-aug-2012,

      now how do i convert this text into date format and compare with todays date in sql and fetch only last 2 days data

       

      in short ,what should be my where statement to get last two days data???

       

       

      any help would be appreciated

       

      Thanks

      Sudeep