topic Re: Date Range on Selection Screen not working in Application Development and Automation Discussions

Date Range on Selection Screen not working

adeel_sarwar — Fri, 17 Jul 2009 07:59:42 GMT

Hi All,

I have a selection screen with 3 selection options on there to run a report.

1) Today

2) Yesterday

3) This week

Now the first two are working fine but number 3 This Week isn't. Any reason why? This week basically means Monday to Friday of this week. E.g. If I have This week Clicked on Monday it would just show Mondays result, if I run this report on Wednesday with This week clicked it should show Monday, Tuesday & Wednesday.

Regards

Adeel

FORM posting_date .

CLEAR : rg_finl.

IF rb_1 = 'X'.

rg_finl-sign = 'I'.

rg_finl-option = 'EQ'.

rg_finl-low = sy-datum.

APPEND rg_finl.

CLEAR rg_finl.

ELSEIF rb_2 = 'X'.

rg_finl-sign = 'I'.

rg_finl-option = 'EQ'.

rg_finl-low = sy-datum - 1.

APPEND rg_finl.

CLEAR rg_finl.

ELSEIF rb_3 = 'X'.

rg_finl-sign = 'I'.

rg_finl-option = 'BT'.

rg_finl-low = sy-datum.

rg_finl-high = sy-datum - 7.

APPEND rg_finl.

CLEAR rg_finl.

ELSEIF rb_4 = 'X'.

rg_finl[] = s_budat[].

ENDIF.

ENDFORM.

Re: Date Range on Selection Screen not working

Former Member — Fri, 17 Jul 2009 08:05:43 GMT

Hi,

In the third case, LOW & HIGH values are reversed. Try changing them, might work.

LOW = SY-DATUM-7.

HIGH = SY-DATUM.

Regards,

Manne.

Re: Date Range on Selection Screen not working

Former Member — Fri, 17 Jul 2009 08:06:08 GMT

Hello

You a wrong:

Instead


rg_finl-low = sy-datum.
rg_finl-high = sy-datum - 7.

you need:



rg_finl-low = sy-datum - 7.
rg_finl-high = sy-datum.

Re: Date Range on Selection Screen not working

Former Member — Fri, 17 Jul 2009 08:07:27 GMT

HI ,

use this Fm

HRWPC_BL_DATES_WEEK_INTERVAL

BWSO_DATE_GET_FIRST_WEEKDAY

for week calculation.

Regards,

Vijay

Re: Date Range on Selection Screen not working

venkat_o — Fri, 17 Jul 2009 08:08:17 GMT

Change

rg_finl-low = sy-datum.
rg_finl-high = sy-datum - 7.

rg_finl-low = sy-datum  - 7.
rg_finl-high = sy-datum.

Thanks

Venkat.

Re: Date Range on Selection Screen not working

adeel_sarwar — Fri, 17 Jul 2009 08:10:56 GMT

Hi All,

Thanks for your comments. It works now. Vijay, I know enought ABAP to get me by this was a problem by a programmer just trying to fix it.

Any chance you could help me with a code snipplet which I could write and get this working as per your FM?

Thanks