how to write date format in bdc

[Former Member]

how to write date format in bdc report

[Former Member]

Simply use the option WRITE TO to convert the date into the users settings.

Cheers

VJ

[Former Member]

HI vanamali,

1. It should be in the SAME

format,

ie. in the format

in which we manually enter on the screen.

ie. DD.MM.YYYY

(with dots)

2. This format may depend upon the users settings also.

regards,

amit m.

[naimesh_patel]

Hello,

data: l_date(10), d_date like sy-datum.

d_date = sy-datum.

write: d_date to l_date dd/mm/yyyy.

pass l_date to your bdc.

Regards,

Naimesh

[Former Member]

Hi,

You should write the date in the format according to the default settings.Try using some converion exits if they serve the purpose.

[former_member188685]

Hi,

when you are sending the date info from flat file it should be <b>yyyymmdd</b> format, after uploading then BDC will take care according to user settings.

Regards

Vijay D T T.

[former_member215188]

if your format is mm/dd/yyyy when uploading, store it using TYPE char10. then use the same field in bdc. No conversions needed.

but if you need to use that date before using in bdc, you'll have to reformat it to yyyymmdd.

As mentioned in the post above, when using in bdc, it all boils down to the date format settings in the user settings.

The idea is to store it the way youre going to write it (in bdc).

[Former Member]

Hi,

First you have a data decleration i.e data l_format(10) type c.

now if a variable say l_date which is of sy-datum type, you will have to <b>write l_date to l_format</b>, this will transfer the date in which you(user) have set the date format in user settings. Never hard code the format such as dd.mm.yyyy. or mm/dd/yyyy because the may have different formats, and the BDC will fails. After you have used write to to new l_format, pass this new value to BDC recording.

Reward if useful.

Kiran