I have extracted the _open Data View from an old instance and tried to import the 139K CSV records into a Data Extension in the new instance.
However, I got a problem with the "EventDate" field when trying to import the CSV file into the Data Extension: 19K out of the 139K had a "Invalid Date" Validation Error:
Results:
Inserted: 119564
ValidationErrors:
Invalid Date: 19764
I could import successfully the 139K records into a similar Data Extension where the DateEvent field was a Text type instead of a Date type. But I need to have all the records with a Date type for the EventDate field.
I don´t understand why this is happening. All the records should have a valid Date since they were imported directly from the Data View.
What could I do to get all the records imported into a Data Extension with a Date type EventDate?
Thanks, Javi