28 February 2020
Thank you for getting back to us.
This error is related to the fact that due to data type limitations, it is not possible to put an empty string into a field with 'date' data type.
We would recommend either trying such expression:
ISNULL([DATE_CANC]) ? (DT_WSTR,20)NULL(DT_DBDATE) : [DATE_CANC]
This expression will put NULL to the mapped column instead of some date when a CSV field DATE_CANC does not have any value.
Another option is to change the data type of "Date Canceled" to DT_WSTR (this is called "Single Line" in Zoho) and use this expression:
ISNULL([DATE_CANC]) ? "" : [DATE_CANC]
However, if a target field "Date Canceled" already has some value, both expressions will overwrite it with NULL/blank value.
Finally, if you need to keep the existing value for some record, so that the expression does not touch it, you can leave all as is and disregard the error messages. The initial expression works for pasting a new date value to the blank field and updating existing value in the field and returns errors if DATE_CANC is NULL.
If there is already a value in the "Date Canceled" that must not be touched, this is a working variant.
Should you have any questions, do not hesitate to contact us back.