07-18-2005 4:26 PM
Hi folks,
here is the scenario..
SELECT-OPTIONS wdate FOR SY-DATUM.
suppose I enter the date range as 7/11/05 (wdate-low) and 7/17/05 (end date - wdate-high)
w_date = wdate-high.
write: 'the current date', w_date.
write: w_date to to_date ddmmyy.
I need to determine the from_date which is 120 days subtracted from the to_date in this case it should be
4/17/2005
How should I be doing that?
thanks
Santhosh
07-18-2005 4:31 PM
07-18-2005 4:31 PM
i think that you can use a function SUBTRACT_TIME_FROM_DATE,
regards
07-18-2005 4:31 PM
07-18-2005 4:42 PM
07-18-2005 4:44 PM
This is giving a very different value. it is not working.
santhosh
07-18-2005 4:51 PM
Rich,
I do not want the from_date value i.e 120 days subtracted from high value within the select options but I need to store that value in a different variable altogether.
Santhosh
07-18-2005 4:53 PM
07-18-2005 4:56 PM
07-18-2005 5:06 PM
Hi ,
Try using the Function <b>DATE_IN_FUTURE</b>
set the parameter ANZAHL_TAGE to -120 (for number of days ) and IMPORT_DATUM as the to date.
in this case you will have to pass the date in external format .
another Function is <b>CALCULATE_DATE</b>in which you can pass the date in the internal format.
Regards
Arun
Message was edited by: Arun Ramachandran