I am using Skyvia to move data from SQL Server to Salesforce. The first task is mapping about 15 fields in which 2 of them are date fields. The source data for these 2 fields are 12/31/9999 - Unfortunatley Saleforce allows a max year of 3999 . I tried using REPLACE(cms_expiration,9999,3999) and it gives a cast error
The function "REPLACE" does not support the data type "DT_DBTIMESTAMP" for parameter number 1. The type of the parameter could not be implicitly cast into a compatible type for the function. To perform this operation, the operand needs to be explicitly cast with a cast operator.
Can you please let me know how to make this translation ?