I am receiving the Date and Time as a string(without relevant separators) in XI3.0 from SAP Idoc source.The Date is like 20050519 and the time is like 142030.
The required format at target structure is as follows:
I understand that the XI standard Date conversion function
DateTrans will not handle date without separators.Is there any alternative standard function available in
If any of the forum members have tried writing simple or advanced function for the above requirement?
If you could share the info,it will be Great.
Thanks in advance,
Hi Leo -
What SP are you on? I'm on SP11, and I'm able to do what you're talking about with the standard function. Although the dropdown doesn't list a source format without separators, you can simply edit the drop down & remove the separators, making it yyyymmdd, and your conversion will work. It's the same with the time - it doesn't list time formats, but you can type one in (I did HH:mm:ss for your example...) It's using the standard date formatting behind the scenes, so you can list any format that's valid. Let me know if this doesn't make sense.