topic Re: Date Conversion??? in Application Development and Automation Discussions

Date Conversion???

Former Member — Thu, 13 Jul 2006 05:48:27 GMT

Hi All,

Please tell me is there any Function Module for the conversion of date formats??

My requirement is to get date in this format DD.MM.YYYY even when the user uses any XYZ format.

Thanks in Advance!!!

Seema.

Re: Date Conversion???

Former Member — Thu, 13 Jul 2006 05:52:42 GMT

HI,

Use FM CONVERT_DATE_TO_EXTERNAL

Best regards,

Prashant

Re: Date Conversion???

Former Member — Thu, 13 Jul 2006 05:56:51 GMT

Hi,

U can use,

CONVERT_DATE_TO_EXTERNAL : Converts date from system storage format to users specified display format .

Also,

http://www.sapdevelopment.co.uk/fmodules/fmssap.htm

might help you.

Re: Date Conversion???

Former Member — Thu, 13 Jul 2006 06:00:56 GMT

Hi Seema,

I do not think that there will be any FM that will convert 'any XYZ format' to the date format DD.MM.YYYY.You first have to specify the date format that you want to change.

Re: Date Conversion???

andreas_mann3 — Thu, 13 Jul 2006 06:04:47 GMT

hi,

or simply use command: write... to (using edit mask)

->look F1 to write to

Re: Date Conversion???

Former Member — Thu, 13 Jul 2006 06:05:25 GMT

Hi Seema,

Since your Date format is not decided(xyz format), I think you need to decide your approach.

To dispaly the Date form System Format to User Format the FM <b>'CONVERT_DATE_TO_EXTERNAL'</b> is used.

Consider this code.


REPORT zztest_arun_2.

DATA: e_date(10) type c VALUE '2/2/2006',
      i_date(10).

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'
  EXPORTING
    date_external            = e_date
  IMPORTING
    date_internal            = i_date
  EXCEPTIONS
    date_external_is_invalid = 1
    OTHERS                   = 2.
IF sy-subrc <> 0.
  MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
          WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.

WRITE : / 'CONVERT_DATE_TO_INTERNAL',
        / 'My   Date:' , e_date  ,
          'Conv Date:',  i_date.

          skip 2.

 CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'
  EXPORTING
    DATE_INTERNAL                  = sy-datum
  IMPORTING
    DATE_EXTERNAL                  = e_date
  EXCEPTIONS
    DATE_INTERNAL_IS_INVALID       = 1
    OTHERS                         = 2
           .
 IF sy-subrc <> 0.
 MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
 ENDIF.


 WRITE : / 'CONVERT_DATE_TO_EXTERNAL',
         / 'My   Date:' , sy-datum,
           'Conv Date:',  e_date.

Regards,

Arun Sambargi.