Not able to import date in my target table using import set

[--oooo--]

Hello experts,

I am trying to import data from my excel to the target table but I am getting errors. even I set the date format in filed map.

I have attached a screenshot below .please check it once.

Thank You

[Sai Kumar B]

@--oooo-- 

Is the source table field type "date"? If not you'll have to write a source script in the field map record to convert the string data to date type.

If I could help you with my response you can mark it as helpful and correct as it benefits future viewers
Thanks,
Sai Kumar B
Community Rising Star 2023 & 2022

[Teja11]

Hi @--oooo-- ,

Can you share more data regarding this

Screenshots of the transform map, field mappings and transform scripts if any would be helpful

Regards,

Teja

[--oooo--]

Hello @Teja11 ,

I did not have any transform script I tried to change the date format from the filed map but I am not able to change it. I have attached my excel sheet screenshot, filed map screenshot, transform map, and target table form. please check it once .

Thank You.

[Teja11]

Check the field types in both source table and target table.

Maybe one field is DateTime and other one is Date type.

Regards,

Teja