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

Output Date format

former_member537255 — Fri, 15 May 2009 23:53:39 GMT

Hello,

When i try to print a purchase order on Me23n the date cames inverted as : MM/DD/YYYY

I ´ve debug the program LSTXFCN and when it put the date information in variable cd_date_out

(line 245) , it´s comes as í showed above.Have anyone a sugestion ? My ambients are equalized . But in development it´s working , and not in Production . I´didn´t found notes about it .

Eg:

Prodution : MM/DD/YYYY - wrong

Development: DD.MM.YYYY - is correct

Thank a lot

Re: Output Date format

Former Member — Sat, 16 May 2009 00:34:06 GMT

Do change the user profile.

In dev you might have got profile set as per yu desired format. set the same format in QA too.

Path:System~~>use profile~~->own data

under the Tab(Defaults) change to your desired format

Re: Output Date format

Former Member — Sat, 16 May 2009 10:37:21 GMT

Hi,

Date Format always depends on the way you have chosen in your profile. It can be changed by Basis guys or you can do that if you have access to SU01 transaction,

But, if you drill down to the database level, it always get stored in the format yyyymmdd.

Thanks,

Babu Kilari

Re: Output Date format

Former Member — Sat, 16 May 2009 12:06:52 GMT

hi,

use the function module before passing the date to BDC field or varaible cd_date_out..

CONVERT_DATE_TO_INTERNAL :--Converts internal date to user-specific format string and vice versa. Import/Export : YYYYMMDD;

Export/Import : user specific

See field DATFM in the

USR01 table. Can be set up

via System -> User Profile ->

User Defaults or using su50.

after the getting the date field in the user specified format pass into BDC varaible..

this will solve your problem..

Regards,

Prabhduas

Re: Output Date format

Former Member — Sat, 16 May 2009 13:54:47 GMT

Hi,

You can use this statement in the sap script

/: SET DATE MASK = 'MM.DD.YYYY'