When transforming import set data, Date/Time fields use the user's preferred date format - Known Error

When transforming import set data, Date/Time fields use the user's preferred date format Description When transforming import set data, Date/Time fields use the user's preferred date format which can conflict with the expected format.

Steps to Reproduce

Create a simple Excel or CSV data source. Create a transform map and have a field mapping from [sys_created_on] to another Date/Time field on the target table. Go to a valid User [sys_user] record and change their date_format to dd.MM.yyyy. Impersonate the user from step 3. Execute the data source. Note the error: Unable to format using format string yyyy-MM-dd hh:mm:ss for field Workaround On the transform map field mapping, change the Date format to be the same as the user's preferred format.