Troubleshooting Import – Missing data as a result of a wrong date format

This issue is related to data import and transform. Data is successfully imported into a staging table, but when the data is transformed to a target table, some or all date/time values are missing.

Symptoms

• Import says complete, but not all data is present
• Data discrepancy after import
• Import set has error

When creating the transform map for the new import set, you are adding a field map for a date type field. A field map has a date format attribute you must populate with the format of the date values. The date format is either wrong or was not set, causing the system to use the default date format. In either case, the date format used is different than what the incoming date values are using.

To solve the issue, set the date format on the field map to match the format of the data.