Skip to Content
author's profile photo Former Member
Former Member

date converison

i need to change the date conversion to mm/dd/yyyy how can i do that

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 08:34 AM

    hi

    Please try this FM.

    CONVERSION_EXIT_INVDT_INPUT

    CONVERSION_EXIT_INVDT_OUTPUT

    1) <b>CONVERT_DATE_TO_INTERN_FORMAT</b> Converts a date to internal format

    2) <b>CONVERT_FIELD_TO_EXTERN_FORMAT</b> Converts a field from internal to external format

    3) <b>CONVERT_FIELD_TO_INTERN_FORMAT</b> Converts a field from external to internal format

    Reward with points for helpful answers

    Cheers

    Alfred

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 08:36 AM

    Hi

    Try using,

    <b>CONVERT_DATE_TO_EXTERNAL</b>

    It Converts date from system storage format to users specified display format .

    or

    Try this,

    <b>WRITE wa_olddate TO wa_newdate MM/DD/YYYY</b>.

    hope this helps!

    best regards,

    Thangesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 08:39 AM

    HI,

    Date = YYYYMMDD

    Concatenate date4(2) ‘ /’ date6(2) ‘/’ date(4) into Date2.

    or

    data : l_date(10) type c .

    concatenate sy-datum6(2) '/' sy-datum4(2) '/' sy-datum(4) into l_date.

    write : l_date.

    or

    data :l_date(10) type c

    CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

    EXPORTING

    DATE_INTERNAL = SY-DATUM

    IMPORTING

    DATE_EXTERNAL = l_date.

    this function module converts date from 20050601 to external format which is specified in user profile.

    Regards,

    Laxmi.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2006 at 08:45 AM

    hi,

    Use the following piece of code.

    DATA: L_DATE(10).

    WRITE sy-datum to l_Date mm/dd/yyyy.

    regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 08:47 AM

    hi

    good

    no function module can help you to change the date conversiton,

    you have to store your complete date in a variable and split the three part and store in different variable.Take another variable and store only '/'.

    use CONCATENAE statement to contatenate all the characters and display them using another character variable.

    thanks

    mrutyun^

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.