topic Re: date format in Application Development and Automation Discussions

date format

Former Member — Tue, 13 Jun 2006 20:05:52 GMT

Hi,

I have date on my selection screen and updating fk02 using bdc.

date parameter has different format and date in fk02 has different format, which causing error while updating.

could you please let me know how to change date format, is there any settings need to be changed.

Thanks

Re: date format

Manohar2u — Tue, 13 Jun 2006 20:08:22 GMT

Normally date defualt settings will in user settings, you can go from menu system-utilities' users own data. or SU01 tcode.

There you set the detault date formats for a user.

Also irrespective of date format in bdc you can do by moving the date into char(10) field and then passing this into screen field in bdcdata table.

Regds

Manohar

Re: date format

abdul_hakim — Tue, 13 Jun 2006 20:12:58 GMT

hi raj how ur date format looks currently and what is the expected format?

Cheers,

Abdul Hakim

Re: date format

Former Member — Tue, 13 Jun 2006 20:16:32 GMT

Just do the following

WRITE my_input_date TO my_bdc_field.

Re: date format

former_member181966 — Tue, 13 Jun 2006 20:17:38 GMT

In BDc you can read user date format like this ..it reads from TR.SU3 . I`m using for every BDC. we have written a custom FM . we pass date and it`ll retrun as per user format

RETRIEVE USER PROFILE DATE SETTING

select single datfm

into user_setting

from usr01

where bname = sy-uname.

and then reformat it ...

Hope this’ll give you idea!!

P.S award the points.

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: date format

Former Member — Tue, 13 Jun 2006 21:22:52 GMT

Make sure that the person running the program and the person running the BDC have the same date formats in their profiles.

Rob

Re: date format

Former Member — Tue, 13 Jun 2006 21:51:57 GMT

I am hoping that this is not a batch input session processing. I am assuming that this is a call transaction, in which case the person who is executing the program will be the one who will be executing the transaction.

Re: date format

Former Member — Tue, 13 Jun 2006 22:03:12 GMT

In that case, writing the date to the BDC field should work, but it sounds like the date on the selection screen has a different format from the transaction. That's why I'm thinking session processing by different people.

Rob

Re: date format

venkat_o — Wed, 14 Jun 2006 02:09:19 GMT

Hi Raj,

1.

Assume P_begda is Selection-screen date.

2.

Declare one variable like this.

DATA :l_begda(10),

3.

Use the below statement before populating BDCDATA table

WRITE p_begda TO l_begda.

4.

Pass L_begda like this.

PERFORM bdc_field USING 'RP50G-BEGDA'

l_begda.

I think that this helps u .

Thanks,

Venkat.O

Re: date format

Former Member — Wed, 14 Jun 2006 02:29:17 GMT

you could try moving the field first to a variable with type datum or sy-datum and pass that field to the field in the BDC. Use "move" or "write" not "=".

we cannot ask the user to change his/her settings in SU01.