check the date format

[Former Member]

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......

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

or

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

[Former Member]

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 *