SF Integration Center calculated field, multiple substrings from one field

[Lucazz]

Hi Everybody,

I try to cerate my own integration between SF Platform and Learning Administration.

The date from data model looks like this - 2003-04-01T00:00:00Z

The desired format is - "04/01/2003"

If I treat this data as date I can convert it to a desired format but without double quotes.

In order to achieve a desired date format I'm trying to create a calculated field with date as string. However I'm struggling with concatenating substrings.

Any hints how to achieve something like this pseudo formula ?

<dblquotes> + mid(DATE,5,2) + "/" + mid(DATE,8,2) + "/" + left(DATE,4) + <dblquotes>

[Romanin]

Hi Lukasz, I hope you are doing well.

Handle Data across the Platform sometimes is hard to execute.

I did some tests and I think that is possible to construct your field using "Prepend Text" and concatenate at final string using "Concatenate/Append".

We have several functions in Integration Center that help you in build them.(Integration Center (sap.com) - Page 95)

Here you can find more some relevant information >> Integration Center - SAP Help Portal

I hope this help.

Regards
Daniel Romanin