cancel
Showing results for 
Search instead for 
Did you mean: 

SAP CPI dateTrans Function Returning Incorrect Date During Conversion

10-07-2026 5:15 PM
66 views 0 comments
0 Likes
Subscribe

We are using the dateTrans function in SAP Cloud Integration (CPI) to convert a datetime value from the format:

yyyy-MM-dd HH:mm:ss

to:

yyyy-MM-dd

However, the dateTrans function is producing an incorrect output.

Input

2026-10-07 18:15:00

Expected Output

2026-10-07

Actual Output

2027-03-07

The input date is being converted to a completely different date, even though the expected behavior is only to remove the time portion and retain the date.

Steps to Reproduce

  1. Create a mapping in SAP Cloud Integration.
  2. Use the dateTrans function for date conversion.
  3. Provide the input value:

2026-10-07 18:15:00

  1. Configure the conversion from:

yyyy-MM-dd HH:mm:ss to: yyyy-MM-dd

0 Likes

Accepted Solutions (0)

Answers (0)