HELP REQ IN SIMPLE CODE TO RETRIEVE DATA

[Former Member]

Hi all,

i need to retrieve data from an internal TABLE whose date field is multiple of 2 days behind from current date.

like todays date is 14/08/06

i need records of date 12/08/06,10/08/06,8/8/06,6/8/06,4/8/06 .....

any help would be appreciated

THANKS

[suresh_datti]

Didn't sy-datum - 2 help?

~Suresh

[RichHeilman]

You can use a range for this and build it on the fly. The only question is how far back do you want to go. I mean, how many dates to add to the range. Here I'm only adding 10.

report zrich_0001.

<b>ranges: r_datum for sy-datum.

r_datum-sign = 'I'.
r_datum-option = 'EQ'.
r_datum-low  = sy-datum.  append r_datum.
do 10 times.
  r_datum-low  = r_datum-low - 2.  append r_datum.
enddo.</b>


select .....
          <b>where datum in r_datum</b>.

Regards,

Rich Heilman