Symptom
- 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).
Read more...
Environment
SAP Cloud Integration for data services
Product
SAP Cloud Integration for data services 1.0
Keywords
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 page
This 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.