Date format

[raviteja_satuluri]

Hi Experts,

Please help on the below mapping requirement.

The Out put is like

For example input 20150912T093055 and output we want 09:30:55AM on September 12,2015.

Please provide the solution with Screenshots.

Thanks and Regards,

Kamal S.

[markangelo_dihiansan · Accepted solution]

Hi Kamal,

This can be achieved using date trans. Screenshot below:

For the date: substring is 0..8

For the time: substring is 9..0

Output:

Apologies for the output, just reverse the concat and it should be fine.

Regards,

Mark

[former_member257758]

Hi Kamal,

Pls refer the below link.

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/04/09/mapping-logic-to-convert-time-for...

Hope this helps.

Arun