topic Re: date conversation in Application Development and Automation Discussions

date conversation

Former Member — Mon, 29 May 2006 06:31:25 GMT

hi friends,

when uploads date it should accept all format and upload to the table

upload is from excel to tcode

plz give the exact code

<u>my itab field</u>

datsl LIKE rm63e-datsl,

<u>recorded date field</u>

perform bdc_field using 'RM63E-DATSL'

file_int-datsl.

thanks,

soorya

Re: date conversation

Former Member — Mon, 29 May 2006 06:34:04 GMT

Soorya,

To a BDC the date always should be passed in the external format. So, just take the values as it is from the excel and just before passing to the PERFORM, call CONVERT_DATE_TO_EXTERNAL and pass the formatted date.

Regards,

Ravi

Note : Please mark the helpful answers

Re: date conversation

Former Member — Mon, 29 May 2006 06:38:12 GMT

Hi soorya,

1. For BDC purpose,

the format of date field

should not be YYYYMMDD.

2. Instead, it should be

AS IT IS

WHILE ENTERING MANUALLY THE DATA ON THE SCREEN.

3. Now, this depends upon the individual users format.

4. To make our code, independent of user format,

its better to use like this :

5. data : dtstr(10) type c.

write sy-datum to dtstr.

(write will write the date into character variable

dtstr AUTOMATICALLY IN THE USERS FORMAT)

6. Then we just need to use this new variable

DTSTR in our bdctable.

7. Thats all !

regards,

amit m.

Re: date conversation

Former Member — Mon, 29 May 2006 06:38:25 GMT

Hi,

you need not to worry about it, it will be automatically converted to default format.

regards

vijay

Re: date conversation

Former Member — Mon, 29 May 2006 06:38:34 GMT

u can move the date to string field and split it accordingly and concatenate it in the desired format and then pass it to the relevant internal table..

reward points if it helps

gunjna

Re: date conversation

Former Member — Mon, 29 May 2006 06:40:05 GMT

Hai Soorya

ISM_CONVERT_DATE_CATEGORY

ISM_CONVERT_DATE_CATGRY_SINGLE

ISM_CONVERT_TO_DATE_CATEGORY

ISP_CONVERT_TO_VISIBLE_DATE

RKE_CONVERT_DATE_TO_LOGNR

RKE_CONVERT_DATE_TO_PERIOD

CONVERT_DATE_FORMAT

OIUHS_INTEGRATION_EPRZ_EXT OIUHS_CONVERT_DATE

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATE_TO_INTERNAL

SCAL

DATE_CONVERT_TO_FACTORYDATE

FACTORYDATE_CONVERT_TO_DATE

SCA_CALENDAR_CONVERSION

CONVERT_CALENDAR_DATE

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATE_TO_INTERNAL

SCAL

DATE_CONVERT_TO_FACTORYDATE

FACTORYDATE_CONVERT_TO_DATE

SCA_CALENDAR_CONVERSION

CONVERT_CALENDAR_DATE

SCON

CONVERT_DATE_INPUT

CONVERT_DATE_WITH_THRESHOLD

SLS_MISC_CONVERT_TO_DATE

ADDR_CONVERT_DATE_TO_TIMESTAMP

ADDR_CONVERT_TIMESTAMP_TO_DATE

CONVERT_DATE_BY_PERIOD_INPUT

CONVERT_DATE_INPUT

CONVERT_DATE_WITH_THRESHOLD

SLS_MISC_CONVERT_TO_DATE

ADDR_CONVERT_DATE_TO_TIMESTAMP

ADDR_CONVERT_TIMESTAMP_TO_DATE

CONVERT_DATE_BY_PERIOD_INPUT

Thanks & regards

Sreeni

OIUREP_ROY_STAT_AND_CNTRL