Migration 21R1 Error formatting date value 11/16/2022 for CREATION_DATE

Hi @HDZSTEPHANIE ,

Could you please give an information which migration tool your are using?

Thanks
Martina

I am using Data Migration, not Data Migration Manager

Hi @HDZSTEPHANIE ,

I guess you are using two migration jobs. One for loading the data from csv (Procedure = CREATE_TABLE_FROM_FILE) and one for migrating the loaded data into the IFS tables (Procedure = MIGRATE_SOURCE_DATA)

In the first job, where you load your data from the csv file into the temporary IFS table you can define how the date format in your legacy file looks like
E.g. you have a date in your csv  24-12-2022
Then you enter DD-MM-YYYY in the job
when you have 2022/12/24 then you need YYYY/MM/DD

 

This is the attribute field prior to unpacking the file:

After unpacking, the attribute field looks like this:

After executing the job, the customer creation date shows as this:

@HDZSTEPHANIE : are those records updated or inserted? Creation_date is a only insertable. It’s not possible to update the field atferwards when the record is already created.

I am doing an insert/update.  Perhaps that is my problem.