Has anyone had this error on import: Unable to format -undefined-undefined using format string yyyy-MM-dd for field u_rehire_date

[fred3d]

Has anyone had this error on import: Unable to format -undefined-undefined using format string yyyy-MM-dd for field u_rehire_date.

[bernyalvarado]

Hi Frederick,

It appears that the variable that you're expecting on your import does not exist.

Thanks,

Berny

[bernyalvarado]

Make sure you validate which field is been mapped to u_rehire_date and that's properly set/named on the import definition and import table.

Thanks,

Berny

[tonemking]

Hi Fred,

Being that its saying undefined-undefined the transform script is looking at a blank field in your file. Its trying to run a script on an empty value. Add a condition that in your transform script that ignores blank fields before converting the date.

This type of error is less concerning as your table will still update if values are present, it is just letting you know that it did not transform an empty field to a date string.

Best,

Tone