Unable to format 29/09/2021 using format string yyyy-MM-dd HH:mm:ss for field u_warranty_start_date

[Ankita34]

we are trying to import data using excel sheet but we are reieving below error in contract table.

Unable to format 29/09/2021 using format string yyyy-MM-dd HH:mm:ss for field u_warranty_start_date.

[Ankur Bawiskar]

Hi,

ensure this

1) all the dates in the excel column are having same format

2) did you specify the format in the field mapping

If the incoming date format is DD/mm/yyyy then give that in field mapping

Example:

Regards
Ankur

[Ankur Bawiskar]

@Ankita 

Hope you are doing good.

Did my reply answer your question?

If my response helped you please mark it correct to close the question so that it benefits future readers as well.

Regards
Ankur

[scottl]

This does not work, as a OOTB client script reverts your custom date format back to the target field data type.

[Welberth Lima1]

It's works! Thanks!