topic Re: Date format conversion in Application Development and Automation Discussions

Date format conversion

Former Member — Thu, 08 Jun 2006 07:23:05 GMT

Hi,

I need to convert date format from one to another. e.g. I need to convert 01.06.2006 to 01 Jun 2006...can anyone provide me with function module for this.

Thanks

Riyaz

Re: Date format conversion

Former Member — Thu, 08 Jun 2006 07:25:14 GMT

use table t247 with elect logic...

parameters: date like sy-datum.

data: begin of itab occurs 0,

SPRAS type SPRAS,

MNR LIKE T247-MNR,

KTX LIKE T247-KTX,

LTX LIKE T247-LTX,

end of itab.

DATA : month LIKE T247-MNR.

DATA: YEAR(4).

DATA: FINAL(18).

DATA: DAY(2).

DAY = DATE+6(2).

MONTH = DATE+4(2).

YEAR = DATE+0(4).

select SINGLE * from t247 into itab where mnr = month

AND SPRAS = 'E'.

APPEND ITAB.

CONCATENATE DAY ITAB-KTX YEAR INTO FINAL SEPARATED BY '-'.

WRITE: FINAL.

Re: Date format conversion

dani_mn — Thu, 08 Jun 2006 07:29:55 GMT

IF you want to avoid SELECT statement.

You can write a little code to do this.

CASE DATE+3(2).

WHEN '01'

CONCATENATE 'JAN' TO datefield.

WHEN '02'

CONCATENATE 'FEB' TO datefield.

So on....

Regards,

Wasim Ahmed

Re: Date format conversion

Former Member — Thu, 08 Jun 2006 07:40:21 GMT

hi,

Check this link which contains a list of FM related to date Convertions

http://www.geocities.com/victorav15/sapr3/abapfun.html

Regards,

Santosh

Re: Date format conversion

Former Member — Thu, 08 Jun 2006 10:58:14 GMT

Have you tried

WRITE SY-DATUM DD/MMM/YYYY.

There are various conversion exits you can use, search SE37 with 'CONVERSION_EXIT_DAT_OUTPUT'.

MattG.