topic Re: DATE fromat converson in Application Development and Automation Discussions

DATE fromat converson

Former Member — Mon, 09 Apr 2007 14:56:28 GMT

hi,

i want convert date format my database date format is 20070327.

but i want convert this format 27.03.2007 how to do this give me the solustion imediatly.

thaks.

rahulkavuri — Mon, 09 Apr 2007 14:58:22 GMT

You can use the function module CONVERSION_EXIT_SDATE_OUTPUT

data: dat type sy-datum, txt(20).

dat = sy-datum.

CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'

EXPORTING

INPUT = date

IMPORTING

OUTPUT = txt

Former Member — Mon, 09 Apr 2007 15:00:12 GMT

Hi,

If you want the user format, then you need to write the below logic,

lets say your date field is L_dat.

Data: date(10) type c.

write L_dat to Date.

write:/ Date. " This will have the user foemat

even, you can use the Function module CONVERT_DATE_TO_EXTERNAL to convert the date to a External format

Regards

Sudheer

Former Member — Mon, 09 Apr 2007 15:00:15 GMT

Hi,

Concatenate itab-date6(2) '.' itab-date4(2) '.' itab-date+0(4) into itab-date.

Shreekant.

Former Member — Mon, 09 Apr 2007 15:00:27 GMT


DATA: NEW_DATE(10) TYPE C.

CONCATENATE OLD_DATA+6(2) OLD_DATA+4(2) OLD_DATA+0(4) 
INTO NEW_DATE SEPARATED BY '.'.

Greetings,

Blag.