topic Re: converting date into text. in Application Development and Automation Discussions

converting date into text.

Former Member — Tue, 01 Aug 2006 11:17:07 GMT

Hello,

Is there any SAP FM available which takes the date (DD.MM.YYY) and convert it sumthing like 'August 01 2006'

Re: converting date into text.

Former Member — Tue, 01 Aug 2006 11:18:27 GMT

Hi shehryar,

1. we can use the fm

CONVERSION_EXIT_SDATE_OUTPUT

2. it will convert into

01-jan-2006 format.

regards,

amit m.

Re: converting date into text.

Former Member — Tue, 01 Aug 2006 11:20:34 GMT

hi,

There is a FM <b>CONVERSION_EXIT_SDATE_OUTPUT</b> to do that.. just check it.

data: date type sy-datum, text(20).
 
date = sy-datum.
 
CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'
  EXPORTING
    INPUT         = date
 IMPORTING
   OUTPUT        = text
          .

Re: converting date into text.

Former Member — Tue, 01 Aug 2006 11:20:42 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 ITAB-KTX DAY YEAR INTO FINAL SEPARATED BY '-'.

WRITE: FINAL.

Re: converting date into text.

Former Member — Tue, 01 Aug 2006 11:22:26 GMT

check out the table T247. You can convert months to text using this table.

Use function module DATE_COMPUTE_DAY for getting the day number.

Re: converting date into text.

Former Member — Wed, 23 Nov 2011 07:00:41 GMT

Useful FM CONVERSION_EXIT_SDATE_OUTPUT

.. thanks:)

Re: converting date into text.

Former Member — Wed, 23 Nov 2011 09:58:30 GMT

you can use fm CONVERSION_EXIT_SDATE_OUTPUT for conversion of date to text. Hope this will solve your problem.

thanks

Edited by: Ankitesh on Nov 23, 2011 10:59 AM

Re: converting date into text.

mamun_eitekh92 — Tue, 06 Sep 2022 09:28:29 GMT

Thanks. It worked