topic Re: Problem With DATE format. in Application Development and Automation Discussions

Problem With DATE format.

Former Member — Wed, 04 Mar 2009 10:36:11 GMT

Hi Frineds,

I have created ztable which will have the fileds like :

MANDT type MANDT

REPORT_ID type ZREPORTID,

SELNAME type RSSCR_NAME,

SIGN type TVARV_SIGN,

OPTION1 type TVARV_OPTI

LOW type TVARV_VAL

HIGH type TVARV_VAL.

in this table I am stroing all the default values for selection-screen in webdynpro-abap.

but for the selection-screen filed Begda( For any date filed ), I am Unable to set the Value as it is.

It is stored as 02/02/2009, but when it comes to screen it is getting displayed as 2//20/02/0.

I am sure with data type problem. but I can't change the Low type as it afftects the other fileds which are not date format.

Kindly,Help me.

Regards,

Xavier.P

Re: Problem With DATE format.

Former Member — Wed, 04 Mar 2009 10:40:03 GMT

Hi,

Store the data as 20090202 instead of 02/02/2009. when you moving 02/02/2009 to date field it is again converting the date to user format.

EX..

MANDT = sy-mandt.

REPORT_= sy-repid.

SELNAME = 'P_DATE'

SIGN = 'I'.

OPTION1 = 'EQ'.

LOW = '20090202'.

HIGH = ' '.

Edited by: Avinash Kodarapu on Mar 4, 2009 4:10 PM

Re: Problem With DATE format.

Former Member — Wed, 04 Mar 2009 10:45:16 GMT

Hi,

Actually due to user settings we get the data like 04/03/2009. But actually system processes theses data as 20090304. So give ur data in this format YEAR MONTH DATE .

in ur case give it 20090202.

Cheers,

Rudhir

Re: Problem With DATE format.

Former Member — Wed, 04 Mar 2009 10:49:32 GMT

Hi,

In your ABAP editor choose SYSTEM >> USER PROFILE >> OWN DATA and in the date format choose the desired conversion... it will be displayed in that order.

Thanks,

Rohan