function module for date

[Former Member]

hi all,

plz tell me the function module to get the date field in below format 'mmm-dd-yyyy' ?

thank u

[naimesh_patel]

Check this FM: CONVERSION_EXIT_IDATE_OUTPUT

It will return you a date in 'MMMDDYYYY' format.

Regards,

Naimesh Patel

[Former Member]

then how to get that out put into this format MMM-DD-YYYY?

[naimesh_patel]

Try like this:

REPORT  ZTEST_NP.

DATA : I_DATE(09) ,
       L_DATE(12).

CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'
  EXPORTING
    INPUT  = SY-DATUM
  IMPORTING
    OUTPUT = I_DATE.
CONCATENATE I_DATE+0(3) I_DATE+3(2) I_DATE+5(4) INTO L_DATE
SEPARATED BY '-'.

WRITE : L_DATE.

Regards,

Naimesh Patel

[Former Member]

Hi,

You can use the FM CONVERSION_EXIT_PDATE_OUTPUT

Thanks,

Sriram Ponna.

[Former Member]

Hi Sunil,

Use FM CONVERSION_EXIT_SDATE_OUTPUT to convert date to dd.mmm.yyyy (date_out) format.

Pass date in yyyymmdd format.

concatenate date_out3(3) '-' date_out0(2) '-' date_out+7(4) into date_output.

Lokesh

[Former Member]

try this...

DATA : DATE TYPE char20.

CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'

EXPORTING

input = sy-datum

IMPORTING

OUTPUT = date

.

CONCATENATE DATE2(3) DATE0(2) DATE+5(4) INTO DATE

SEPARATED BY '-'.

WRITE : DATE.

[Former Member]

Hi,

Try this code.

DATA: DATE_CHAR(20).

DATA: DATE TYPE SY-DATUM.

DATA: MONTH_NAME LIKE T247-KTX.

DATE = SY-DATUM.

SELECT SINGLE KTX FROM T247

INTO MONTH_NAME

WHERE SPRAS = SY-LANGU

AND MNR = SY-DATUM+4(2).

CONCATENATE SY-DATUM+6(2) MONTH_NAME SY-DATUM(4)

INTO DATE_CHAR SEPARATED BY SPACE.

WRITE: / DATE_CHAR.

Reward if helpful.

Regards,

Harini.S