Field "Valid From" from sheet "Master Record" has a wrong data type in line 9

[Afshin_IR]

Hi,

I am trying to upload using the Migrate Your Data approach and I keep getting this error. Field "Valid From" from sheet "Master Record" has a wrong data type in line 9 and Field "Valid To" from sheet "Master Record" has a wrong data type in line 9.

My Data looks like this

Thanks

Afshin

[AndreasMuno · Accepted solution]

Thank you for your question, @Afshin_IR.

As you extend your spreadsheet downwards to accommodate for more master data, you may want to use the format painter function (paint brush symbol) of MS Excel to copy the formats of the fields which are filled with valid values to those fields the validity check complains about. To do that, position the cursor into one of the valid fields in column "Valid From". Click on format painter. The field gets surrounded with a moving dashed line. In the same column, mark pristine fields in the lines below the field filled with data. To mark multiple fields at once, consult the help function of your spreadsheet provider, as the command might be different between Windows and Mac computers.

If this solves your problem please mark accordingly.            

[Afshin_IR · Accepted solution]

Thanks , I suspect the error comes from the first row and specifically the data columns. Any more suggestions would help .

[Afshin_IR · Accepted solution]

The correct solution is documented here https://community.sap.com/t5/enterprise-resource-planning-q-a/data-migration-cockpit-date-issue-for-...