topic Date field on Selection Screen in Application Development and Automation Discussions

Date field on Selection Screen

Former Member — Mon, 19 Feb 2007 02:41:50 GMT

Hi All,

I need to create Date field (From and To) in the selection screen. The Date format should appear as YYYY-MM-DD.

I have defined this requirement as below.

select-options: s_date for sy-datum no-extension default sy-datum.

Due to above line, date is appearing in DD.MM.YYYY format.

How to code, so that date should appear in YYYY-MM-DD in the selection screen...????

Please Help me....

Regards

Pavan

Re: Date field on Selection Screen

amit_khare — Mon, 19 Feb 2007 02:49:51 GMT

Hi,

Date format depends on the user settings so vary from user to user unless they are predefined by the Basis team and are blocked for user changes.

So as an alternative you may change the date after user enter it to your desired format, by that you can save your program against user profile changes.

You can smple do that by using WRITE statement with masking.

Regards,

Amit

Reward all helpful replies.

Re: Date field on Selection Screen

Former Member — Mon, 19 Feb 2007 02:50:47 GMT

Pavan,

write below code.

DATA : WS_DATE like sy-datum.

select-options: s_date for sy-datum.

AT SELECTION SCREEN OUTPUT.

call function 'CONVERT_DATE_TO_INTERN_FORMAT'

exporting

datum = sy-datum

dtype = 'DATS'

IMPORTING
ERROR =

IDATE = ws_date.

MESSG =
MSGLN =

s_date-low = ws_date.

Pls. reward if useful

Re: Date field on Selection Screen

Former Member — Mon, 19 Feb 2007 03:15:23 GMT

Thanks

Re: Date field on Selection Screen

Former Member — Mon, 19 Feb 2007 03:17:52 GMT

Pavan,

DATA : WS_DATE(10),

ws_day(2),

ws_mon(2),

ws_year(4).

tables : ADAA.

select-options: s_date FOR ADAA-ACTION.

INITIALIZATION.

ws_year = sy-datum+0(4).

ws_mon = sy-datum+4(2).

ws_day = sy-datum+6(2).

concatenate ws_year ws_mon ws_day into ws_date separated by '.'.

s_date-low = ws_date.

append s_date.

This is working fine.

Pls reward.

Re: Date field on Selection Screen

Former Member — Mon, 19 Feb 2007 03:21:31 GMT

Hi Pavan,

You have to specify this in the user settings only.

Initialization u cant specify this.

Other than that if u want the same format to be used in the program u can convert that using the belwo code

 v_month = fromdate-low+4(2).
 v_year = fromdate-low+0(4).
 v_days = fromdate-low+6(2).
 CONCATENATE v_year '-' v_month '-' v_days  INTO fromdate-low.

And use whereevr needed but cant be shown in the screen.