topic Re: date range in Application Development and Automation Discussions

date range

Former Member — Mon, 18 Jul 2005 15:26:30 GMT

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

Re: date range

Former Member — Mon, 18 Jul 2005 15:31:04 GMT

i think that you can use a function SUBTRACT_TIME_FROM_DATE,

regards

Re: date range

Former Member — Mon, 18 Jul 2005 15:31:37 GMT

from_date = w_date - 120.

Rob

Re: date range

RichHeilman — Mon, 18 Jul 2005 15:42:33 GMT

select-options wdate for sy-datum.

at selection-screen output.

  read table wdate index 1.
  wdate-low = wdate-high - 120.
  modify wdate index 1.

Regards,

Rich Heilman

Re: date range

Former Member — Mon, 18 Jul 2005 15:44:29 GMT

This is giving a very different value. it is not working.

santhosh

Re: date range

Former Member — Mon, 18 Jul 2005 15:51:42 GMT

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

Re: date range

RichHeilman — Mon, 18 Jul 2005 15:53:41 GMT

data: adifferentvariablealtogether type sy-datum.
select-options wdate for sy-datum.
 
at selection-screen .

  adifferentvariablealtogether  = wdate-high - 120.

Regards,

Rich Heilman

Re: date range

RichHeilman — Mon, 18 Jul 2005 15:56:39 GMT

By the way, 120 days from 07/17/2005 is 03/19/2005 not in April.

Regards,

Rich Heilman

Re: date range

Former Member — Mon, 18 Jul 2005 16:06:17 GMT

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