topic Re: sub from sy-datum in Application Development and Automation Discussions

sub from sy-datum

Karan_Chopra_ — Thu, 27 Sep 2007 13:52:02 GMT

how do i subtract 5 dates from sy-date

i wanna select data from int table with date not less than 5 previous dates

Former Member — Thu, 27 Sep 2007 13:55:58 GMT

Just do


data : predate type sy-datum.
predate = sy-datum - 5.

select * from table into itab where date > predate.

Pls reward if helpful.

Message was edited by:

Shori

Former Member — Thu, 27 Sep 2007 13:56:43 GMT

hi Karan,

Try the following...

DATA: lv_date TYPE datum.

lv_date = sy-datum.

SUBTRACT 5 FROM lv_date.

WRITE:/ sy-datum, lv_date.

LOOP AT itab WHERE date GE lv_date.

ENDLOOP.

Hope this helps.

Cheers