Skip to Content
author's profile photo
Former Member

date conversion

hello all,

i want to convert date 2004/11/28 into 28-NOV-2004. can u pls help. it's urgent.

ritu

Add comment
10|10000 characters needed characters exceeded

6 Answers

  • Posted on Aug 17, 2007 at 07:27 AM

    Hi

    You have to Call the FM CONVERSION_EXIT_SDATE_OUTPUT.

    Reward if Helpful

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 17, 2007 at 07:17 AM

    Hi,

    Check the fun modules

    CONVERT_DATE_TO_INTERNAL and CONVERT_DATE_TO_EXTERNAL

    or split the given date to YEAR,MONTH and DATE

    and fetch the month description from the table T247

    and concatenate the Date,month text and year into a string and use

    Reward points for useful Answers

    Regards

    Nilesh

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 17, 2007 at 07:19 AM

    Welcome to SDN.

    Refer the links with solutions for same issue -

    date-conversion

    date-conversion

    Regards,

    Amit

    Reward all helpful replies.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 17, 2007 at 07:36 AM

    Hi,

    Try FM <b>CONVERSION_EXIT_SDATE_OUTPUT</b>

    Input date should be 20071128 not 2004/11/28.

    reward if useful.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 17, 2007 at 07:46 AM

    HI

    USE

    CONVERT_DATE_TO_INTERNAL Function Module

    reward points to all helpful answers

    kiran.M

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 10:58 AM

    thanx all of u.

    Add comment
    10|10000 characters needed characters exceeded