How to convert date format in XI? Help!

[gopalkrishna_baliga]

Hi Experts,

PIP is the input for XI.

The PIP has date as : <DateTimeStamp>20030515T000000.000Z</DateTimeStamp>.

How to convert it into MM/DD/YYYY format in XI?

Thanks

Gopal

[moorthy]

Hi,

You can do it in the mapping right ?

Write any user defined function/ try with using standard DateFormat function in the mapping.

Regards,

Moorthy

[MichalKrawczyk]

hi,

use two standard functions:

<b>substring </b>(to take first 8 chars from this field)

<b>DateTrans</b> to change 20030515 to MM/DD/YYYY

http://help.sap.com/saphelp_nw04/helpdata/en/43/c4cdfc334824478090739c04c4a249/content.htm

that's all you need to do very simple

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>