Im facing some issues regarding Date format.
Im receiving different date formats from a SFTP Connector and need to limit the format to a certain format (YYYY-MM-DD) to be able to perform a upsert to Salesforce. If it is not the right format it should simply reject the record and send a error message.
If I set the format in the mapping to YYYY-MM-DD it stops the whole process instead of rejecting only the given record.
Anyone knows a solution to build that?
Thanks for your help!