cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert the datetime format in SAP CPI

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Harish_Vatsa
Active Contributor

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.