How to convert the datetime format in SAP CPI

[former_member814896]

Hi All,

Requirement is to convert the datetime format. Source structure has two fields. REC_DATE has input format of yyyyMMdd(eg: 20231216) and other field REC_TIME has input format of HHmmss(eg: 121221) . These two fields needs to be mapped to field "CreationDateTime" format of yyyy-MM-dd'T'HH:mm:ss'Z'(eg:2023-12-16T12:12:21Z).

Could anyone please help how to get this.

Thanks,

Jayasri

[Harish_Vatsa · Accepted solution]

Dear mysellff,

Can you please try substring method on REC_DATE and REC_TIME and then concatenate the substrings as per the desired format of 'CreationDateTime' format of 'yyyy-MM-dd'T'HH:mm:ss'Z''.

Thanks,

H.V.