topic Re: function module for date in Application Development and Automation Discussions

function module for date

Former Member — Mon, 17 Dec 2007 14:50:37 GMT

hi all,

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

thank u

Re: function module for date

naimesh_patel — Mon, 17 Dec 2007 14:53:49 GMT

Check this FM: CONVERSION_EXIT_IDATE_OUTPUT

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

Regards,

Naimesh Patel

Re: function module for date

Former Member — Mon, 17 Dec 2007 15:03:02 GMT

Hi,

You can use the FM CONVERSION_EXIT_PDATE_OUTPUT

Thanks,

Sriram Ponna.

Re: function module for date

Former Member — Mon, 17 Dec 2007 15:06:48 GMT

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

Re: function module for date

Former Member — Mon, 17 Dec 2007 15:12:11 GMT

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.

Re: function module for date

Former Member — Mon, 17 Dec 2007 15:25:32 GMT

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

Re: function module for date

naimesh_patel — Mon, 17 Dec 2007 15:33:34 GMT

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

Re: function module for date

Former Member — Mon, 17 Dec 2007 16:05:48 GMT

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