Skip to Content
avatar image
Former Member

converting date format from in mapping

hi xi friends.

in my scenario i just want to convert date format from 12022007 which is file to 12.02.2007 which is in target bapi.

waiting for u.

bye.

regards.

seeta ram.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Jun 14, 2007 at 11:44 AM

    Hi,

    Use the standard DateTrasnform function available in your mapping.

    regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      sorry .

      how we can do can u just tell me please.

      i will be waiting for u r answer.

      bye.

      regards.

      seeta ram.

  • avatar image
    Former Member
    Jun 14, 2007 at 11:50 AM

    Hi,

    Use user defined function in XI.

    Regards

    Hemant

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 14, 2007 at 11:50 AM

    Hi,

    Use TransformDate function from Date.

    Give ddmmyyyy as source form and dd.mm.yyyy as target form.

    Thanks,

    Maheshwari.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 14, 2007 at 11:59 AM

    Hi,

    u can manually write that...it will work.

    Thanks,

    Maheshwari.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 14, 2007 at 12:02 PM

    Hi Seeta Ram,

    Go to ur Message Mapping, at the bottom, u get the options to select the FUNCTIONS. Select DATE, select DateTransform option.

    drag n drop ur source date field n target date field and do the mapping with the DateTransform option. Double click DateTransform. Then u r done.

    Giv ur source format and the required target date format there..

    Hope this helps.

    kanan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 14, 2007 at 12:10 PM

    Hi,

    no need of UDF.

    select TransformDate function from Date category....double click on it.

    for Source date manually write ddmmyyyy (instead of selecting from drop down) & for target date give dd.mm.yyyy manually.

    i think its clear now.

    Thanks,

    Maheshwari.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      if I understood you correctly you want to transform from ddMMyyyy (your format in the external file) to yyyyMMdd (format of ABAP datatype DATS):

      Then all you need to do is to use the standard function TransformDate (as already described above).

      Enter in the field "Format of source Date": ddMMyyyy

      Enter in the field "Target Format": yyyyMMdd

      That's it.

      Regards,

      Helmut

  • avatar image
    Former Member
    Jun 14, 2007 at 12:26 PM

    Hi,

    whether ur problem is solved or not???

    if yes then u can close the thread.

    Thanks,

    Maheshwari.

    Add comment
    10|10000 characters needed characters exceeded