topic Re: date format in Application Development and Automation Discussions

date format

Former Member — Tue, 04 Jul 2006 11:02:59 GMT

hi ,

i have date format coming from the file as yyyymmdd , now i want to convert this in bdc program to user specfic date ( having 10 char) how can i do it . any FM avaiable.

thanks

sridhar

Re: date format

Former Member — Tue, 04 Jul 2006 11:04:50 GMT

You can easly use the statament WRITE:

Create a variable where you'll write the date:

DATA: W_DATE(10) TYPE C.

WRITE <DATE> TO W_DATE.

Transfer W_DATE to BDC

Max

Re: date format

Former Member — Tue, 04 Jul 2006 11:05:20 GMT

write sy-datum to v_date. "v)date should be of 10 char length

or use the func mod:

CONVERT_DATE_TO_EXTERNAL

Regards,

Ravi

Re: date format

Former Member — Tue, 04 Jul 2006 11:05:26 GMT

CONVERT_DATE_TO_EXTERNAL function will do the job.

Regards,

Ravi

Re: date format

Former Member — Tue, 04 Jul 2006 11:05:55 GMT

data: l_date type d value '20060704',

l_text(10) type c.

Write l_date to l_text dd/mm/yyyy.

Re: date format

Former Member — Tue, 04 Jul 2006 11:08:38 GMT

Hello, Please check FM:

CONVERSION_EXIT_PDATE_OUTPUT

Best regards, Murugesh AS

Re: date format

Former Member — Tue, 04 Jul 2006 11:11:51 GMT

Hi Sridhar,

Welcome to SDN........

1)Use Function module <b>CONVERT_DATE_TO_EXTERNAL</b>.

2) DATA V_DATE(10).

<b>WRITE SY-DATUM TO V_DATE.</b>

Note: Plz mark all helpful answers and close the thread if it is solved.

Thanks,

Vinay

Re: date format

Former Member — Tue, 04 Jul 2006 11:12:17 GMT

Hai Sridhar

Check the following Code

DATA: v_date(10) TYPE c.

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

date_internal = '20060604'

IMPORTING

date_external = v_date

EXCEPTIONS

date_internal_is_invalid = 1

OTHERS = 2.

if sy-subrc = 0.

write 😕 v_date.

endif.

Thansk & regards

Sreeni

Re: date format

Former Member — Tue, 04 Jul 2006 11:19:06 GMT

if the date format is in YYYYMMDD,

data : v_externaldate type sy-datum,

data : v_internal_date(10) type c.

write 😕 v_externaldate to v_internal_date.

this WRITE TO will convert date to user logged date format

i.e., with / or . or someother values.

regards

srikanth

Re: date format

Former Member — Tue, 04 Jul 2006 11:36:31 GMT

Hi,

CONVERT_DATE_TO_EXTERNAL will solve your problem.

Regs,

Venkat Ramanan