topic Re: Regarding date in Application Development and Automation Discussions

Regarding date

Former Member — Mon, 18 Feb 2008 12:06:36 GMT

Hi all,

In selection screen have parameter field date. When i used select statement it should pick the data before 90 days

of the selection screen . It should take each and every value

in the internal table.

Please suggest it

please give code.

thanks

venkat

Re: Regarding date

Former Member — Mon, 18 Feb 2008 12:15:12 GMT

Hi Venkat,

Have an field of ldate and subtract the current date with 90 days. and use that in your where condition range (from date i.e ldate to sy-datum) in select statement .

Regards,

JMB

Re: Regarding date

Former Member — Mon, 18 Feb 2008 12:20:25 GMT

ranges : r_date for sy-datum.

date_low = p_date - 90.

r_date-sign = 'I'.

r_date-option = 'BT'.

r_date-low = date_low.

r_date-high = p_date ..

Now use r_date in your select statement to get the data ..

select * from <table> into <itab>

where <date> in r_date.

Re: Regarding date

Former Member — Mon, 18 Feb 2008 12:26:22 GMT

Hi,

tables : vbak.

data : it_vbak like vbak occurs 0,

w_date type sy-datum.

parameters: p_date type sy-datum.

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'

EXPORTING

date = p_date "'20080218'

days = '90'

months = '00'

SIGNUM = '-'

years = '00'

IMPORTING

CALC_DATE = w_date.

select * from vbak into table it_vbak where ERDAT < w_date.