Skip to Content
avatar image
Former Member

convert date from any format to DD.MM.YYYY format

hi,

i need to convert the date from any format to DD.MM.YYYY format.

help out to do so.

thanks and regards

priya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Oct 15, 2008 at 12:15 PM

    Hi

    you can use convert_date_to_external FM to change it in ur required format.

    Regards,

    Vishwa.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 12:16 PM

    use FM

    RSAWBN_DATE_FORMAT

    regards,

    Padma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 12:18 PM

    hi priyadarshini,

    Please use these following Function Modules.

    CONVERSION_EXIT_PDATE_OUTPUT

    Eg: input = 24012008 and output = 24.01.2008

    CONVERT_DATE_FORMAT

    Eg: input = 20080201 and output = 01.02.2008

    CONVERSION_EXIT_SDATE_OUTPUT

    Eg: input = 20070201 and output = 01.FEB.2007

    CONVERSION_EXIT_IDATE_INPUT

    Eg: input = 01.02.2008 and Output = 20080201

    CONVERSION_EXIT_LDATE_OUTPUT

    Eg: input = 20070301 and output = 01. March 2007

    CONVERSION_EXIT_PDATE_OUTPUT

    Eg: input = 20070301 and output = 03.01.2007

    Thanks,

    Murugan.B

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 12:21 PM

    Hi,

    Check this FM -CONVERT_DATE_FORMAT.

    it convert YYYYMMDD to DDMMYYYY format.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 12:25 PM

    What's the "any format"?

    YYYY.DD.MM?

    MM.DD.YYYY?

    MM.YYYY.DD?

    DD.YYYY.MM?

    DD-month-YYYY?

    ... and so on...

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2008 at 12:30 PM

    >

    > i need to convert the date from any format to DD.MM.YYYY format.

    let me tell you, whatever everyone says (except Maen!), this is simply not possible...

    how will the computer decide if for example 01022008 should be converted into 01.02.2008 (First of February - US Date format) or 02.01.2008 (Second of January - UK date format)

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2008 at 12:32 PM

    Try to explain the scenario to get a perfect /quick solution. Because you've mentioned 'ANY FORMAT'.

    Edited by: Vamshi Mohan on Oct 15, 2008 6:02 PM

    Add comment
    10|10000 characters needed characters exceeded