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

date conversion function module

Former Member — Tue, 13 Mar 2007 14:29:56 GMT

Hi All,

Please let me know which fun module can be used to convert the date to this format 01 JAN 2007(IF we pass the system date the output should give like this)

Thanks&Regards

mahesh

Re: date conversion function module

Former Member — Tue, 13 Mar 2007 14:32:56 GMT

try this

REPORT YCHATEST.

DATA : V_DATE(12).
 
CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'
  EXPORTING
    INPUT  = SY-DATUM
  IMPORTING
    OUTPUT = V_DATE.
 
 
WRITE : V_DATE.

Re: date conversion function module

Former Member — Tue, 13 Mar 2007 14:35:36 GMT

Hello,

Use the FM

<b>CONVERSION_EXIT_SDATE_OUTPUT</b>

REward if helps.

Vasanth

Re: date conversion function module

Former Member — Tue, 13 Mar 2007 14:41:47 GMT

You can use DATE_STRING_FORMAT function. It can take the following format codes, in date_format input field

1 DD.MM.YYYY

2 MM/DD/YYYY

3 MM-DD-YYYY

4 YYYY.MM.DD

5 YYYY/MM/DD

6 YYYY-MM-DD

7 GYY.MM.DD (Japanese Date)

8 GYY/MM/DD (Japanese Date)

9 GYY-MM-DD (Japanese Date)

A YYYY/MM/DD (Islamic Date 1)

B YYYY/MM/DD (Islamic Date 2)

So create an interanal table with two fields mapping JAN, FEB, MAR etc to 01, 02, 03 etc. Read the array for your input month and convert your date to DD.MM.YYYY format and then call DATE_STRING_FORMAT which can convert your date to internal date format

For reverse conversion though you can use CONVERSION_EXIT_SDATE_OUTPUT

Re: date conversion function module

Former Member — Tue, 13 Mar 2007 15:22:27 GMT

Hi ALL,

I got the fun module conversion_exit_idate_output which will solve this problem

thanks to u all.