Date Format IN BDC

Former Member — Fri, 29 Sep 2006 05:24:40 GMT

Hi,

In One Interview I was asked that How can You Handle Data Format when Writing BDC ?

Re: Date Format IN BDC

Former Member — Fri, 29 Sep 2006 05:27:34 GMT

Hi,

You have to concatenate '.' in the date to make it 2006.05.05. Once concatenated, then pass the value to the screen field in BDC.

Best regards,

Prashant

Re: Date Format IN BDC

Former Member — Fri, 29 Sep 2006 05:55:41 GMT

Satya,

The date format depends on User settings. Its different for different login ID's.

It can be YYYY.MM.DD or MM.DD.YYYY or anything.

To handle the date format, you need to query on table USR01 and fetch DATFM field that stores date format.

Refer below piece of code

*/...Fetch the date format settings for the user

SELECT SINGLE datfm

INTO gv_date_format

FROM usr01

WHERE bname = sy-uname.

CASE gv_date_format.

WHEN 1. "DD.MM.YYYY

CONCATENATE fv_impdate+6(2) '.'

fv_impdate+4(2) '.'

fv_impdate+0(4) INTO fv_expdate.

WHEN 2. "MM/DD/YYYY

CONCATENATE fv_impdate+4(2) '/'

fv_impdate+6(2) '/'

fv_impdate+0(4) INTO fv_expdate.

WHEN 3. "MM-DD-YYYY

CONCATENATE fv_impdate+4(2) '-'

fv_impdate+6(2) '-'

fv_impdate+0(4) INTO fv_expdate.

WHEN 4. "YYYY.MM.DD

CONCATENATE fv_impdate+0(4) '.'

fv_impdate+4(2) '.'

fv_impdate+6(2) INTO fv_expdate.

WHEN 5. "YYYY/MM/DD

CONCATENATE fv_impdate+0(4) '/'

fv_impdate+4(2) '/'

fv_impdate+6(2) INTO fv_expdate.

WHEN 6. "YYYY-MM-DD

CONCATENATE fv_impdate+0(4) '-'

fv_impdate+4(2) '-'

fv_impdate+6(2) INTO fv_expdate.

ENDCASE.

This would convert the date into the format set for user.

Hope this is helpful.

Amogh

topic Re: Date Format IN BDC in Application Development and Automation Discussions

Date Format IN BDC

Re: Date Format IN BDC

Re: Date Format IN BDC