topic Re: select options on date in Application Development and Automation Discussions

select options on date

Former Member — Wed, 08 Nov 2006 11:22:46 GMT

Hi All,

I have a select-options variable on a date variable in which i want to default the date range as last week. I tried the following but it didnt worked.

SELECT-OPTIONS:

s_date FOR pa0000-begda default sy-datum - 7 to sy-datum.

Any clues how it can be done.

Thanks & Regards,

Rahul Rathi

Re: select options on date

Former Member — Wed, 08 Nov 2006 11:24:18 GMT

SELECT-OPTIONS: S_DATE FOR SY-DATUM.

INITIALIZATION.

S_DATE(3) = 'IEQ'.

S_DATE-LOW = SY-DATUM - 7.

S_DATE-HIGH = SY-DATUM.

APPEND S_DATE.

Max

Re: select options on date

Former Member — Wed, 08 Nov 2006 11:26:07 GMT

hi do like this

SELECT-OPTIONS:

s_date FOR pa0000-begda .

initialization ."event

s_date-low = sy-datum-7.

s_date-high = sy-datum-7.

it wii work now.

mark points if helpful.

regs

manas raznjan panda.

Re: select options on date

Former Member — Wed, 08 Nov 2006 11:28:15 GMT

Hi Rahul,

Try this:

INITIALIZATION.

s_date-low = sy-datum - 7.

s_date-high = sy-datum.

Append s_date.

SELECT-OPTIONS:

s_date FOR pa0000-begda.

Hope this helps you,

Regards,

Pragya

Re: select options on date

Former Member — Wed, 08 Nov 2006 11:33:32 GMT

Hii..

you can try out this code

INITIALIZATION.

S_DATE(3) = 'BT'.

S_DATE-LOW = SY-DATUM - 7.

S_DATE-HIGH = SY-DATUM.

APPEND S_DATE.

Re: select options on date

Former Member — Wed, 08 Nov 2006 11:34:05 GMT

Hi Rahul,

if you mean last week as the last 7 days than use

the mentioned puposes.

If you mean last week as the intervall of the

last week (mo - su) than try the FMs:

GET_WEEK_INFO_BASED_ON_DATE

LAST_WEEK and NEXT_WEEK

and put it in the s_date-low and s_date-high.

Regards, Dieter