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

[Ankur Bawiskar]

@--oooo--

from screenshots I see both the incoming value and target field is of type Date.

Just ensure the Data format you set in field map matches the format from excel.

you need not worry on target field.

data in excel has format as dd-MM-yyyy so in field map also you keep dd-MM-yyyy

If my response helped please mark it correct and close the thread so that it benefits future readers.

[--oooo--]

Hello, @Ankur Bawiskar I tried to change the date format in the field map but I am not able to change it. when i tried to change it after saving that field map form it again showed me the same date format which is yyyy-MM-dd HH:mm: ss.

please guide me on this what should i do now.

Thank You.

[Ankur Bawiskar]

@--oooo-- 

that's strange.

did you try changing the format from list?

[harry_paul]

Hi,

The issue is that the excel data and the transform map format don't match. In excel you have dd-mm-yyyy and in the transform, map field it's the long date format with /. To solve the issue either change all the dates in excel to long dates with / or in the transform map change the format to dd-mm-yyyy.

Hope this helps

thanks:)

[--oooo--]

Thank you @harry_paul @Ankur Bawiskar @Sai Kumar B @Teja11 for youe guidance my issue has been resolved now.