topic Re: check the date format in Application Development and Automation Discussions

check the date format

Former Member — Tue, 02 Jan 2007 07:38:00 GMT

Hi,

Can anybody tell me how to check the date format in BDC while updating.

The system date format is like mm/dd/yyyy. Check the dates format, in case of error return the following message “The date format should be YYYYMMDD”.

Thanks......

Re: check the date format

Former Member — Tue, 02 Jan 2007 07:48:58 GMT

for entreing correct date into transection u have to convert it too yyyymmdd format as systme take only this format from our date format ddmmyyyy

for raise error message for check : u can do it through function module exception handling,

if u are using session method than it better for error checking

regards,

dushyant.

Re: check the date format

Former Member — Tue, 02 Jan 2007 08:02:13 GMT

u should not change ur flat file generally we dont have rights to touch the flat file.

u can change the system date format. goto SU01 enter username there in default tab select the date format which u want.

Logoff & sign in again now ur system date format will be changed

This is allowed for only one user so in ur program while getting data into the internal table use some string manipulation & change the format.

Message was edited by:

Kalpanashri Rajendran

Re: check the date format

Former Member — Tue, 02 Jan 2007 09:01:50 GMT

Dear Anil,

This is a common problem, when carrying out BDC.

For example, while recording you met with the field --> MKPF-BUDAT.

Go to SE11 --> MKPF --> Search for BUDAT --> Double click on the Data Element i.e. BUDAT --> Double Click on the domain DATUM --> You can see under the block Output Characteristics : Output Length = 10.

While declaring the TYPES Structure, make it CHAR(10).

Consider this technique as the Rule-of-Thumb while doing BDC.

Regards,

Abir

***********************************

Don't forget to award points *