topic Re: Date format issue in Application Development and Automation Discussions

Date format issue

Former Member — Wed, 17 Dec 2008 16:36:48 GMT

Hi all,

The user is calling the RFC enabled Function Module from an external system. Am not sure of the which system.

The date format they are expecting is DD-MM-YYYY. But they have an issue stating that this the format is getting chnged to MM-DD-YYYY. It got changed very recently.

And more over SAP system is maintaing the correct date format MM/DD/YYYY

Please give me suggestions what could have went wrong.

Re: Date format issue

Former Member — Wed, 17 Dec 2008 16:41:11 GMT

you can use

WRITE sy-datum TO: date_short,

date_long,

date_mask DD/MM/YY.

Re: Date format issue

amit_khare — Wed, 17 Dec 2008 16:45:07 GMT

Check the code in RFC..it must be modifie or altered.

If SAP is storing correctly qand they are getting it wrong then its only the code.

Re: Date format issue

Former Member — Wed, 17 Dec 2008 17:03:37 GMT

//And more over SAP system is maintaing the correct date format MM/DD/YYYY

sap standard date notation is yyyymmdd

and the system displays the date based on user settings . SU3 usr profile, and USR01 table .

what is the mapping procedure hte external system is using to parse this date field.if its ok from ur end wait till they do the parsing from external sys.

best way to parse is to maintain the sap std notation in yyyymmdd and this makes easy to change the date either to mm-dd-yyyy or dd-mm-yyyy .