converting date format from in mapping

[Former Member]

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.

[Former Member]

Hi,

whether ur problem is solved or not???

if yes then u can close the thread.

Thanks,

Maheshwari.

[Former Member]

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.

[Former Member]

HI.

sorry i understtod u r answer.

but my doubt is in external file the date format is 22012007 and i have to transform this file date format to abap DATS format.

how we can do that.

i think now thw qusetion is clear.

waiting for u r anser.

bye.

regards.

seeta ram.

[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

[Former Member]

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

[Former Member]

Hi,

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

Thanks,

Maheshwari.

[Former Member]

Hi,

Use TransformDate function from Date.

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

Thanks,

Maheshwari.

[Former Member]

hi maheswari.

thanku for the answer.

but there is no . option is transform function.

can u show me the way how we can use . in between dd mm yy.

waiting for u r anser.

bye.

regards.

seeta ram.

[Former Member]

Hi ,

u can write user defined function to create this type of date format.

Regards

Hemant

[Former Member]

thaks maheswari.

but can u give me that UDF code.

waiting for u r response.

bye.

regards.

seeta ram.

[Former Member]

Hi,

Use user defined function in XI.

Regards

Hemant

[bhavesh_kantilal]

Hi,

Use the standard DateTrasnform function available in your mapping.

regards

Bhavesh

[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.