Notifications

Cancel changes

Description

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

Problem

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

Cause

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.

Resolution

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