- The following error occurs while adding/subtracting an integer to/from date:
Cannot add expression <<date column>)> to expression <<integer column>>. Their types are not compatible. Change the expression data types to be numeric.
- The integer column added/subtracted to/from the date column is originally not integer (e.g. varchar), it was converted to integer data type by mapping to an integer column in a transform (implicit conversion).
SAP Cloud Integration for Data Services 1.0.11.xxxx
SAP Cloud Integration for data services 1.0
LOD-HCI-DS, CPI-DS, CI-DS, HCI-DS, HCI, integer, date, conversion , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.