Unable to format 14/08/2021 00:170 using format string yyyy-MM-dd HH:mm:ss for field start_date

[Tara16]

Hi All,

I am getting error while importing change records using transform map. Please suggest?

com.glide.db.impex.transformer.TransformCoercionException: Unable to format 14/08/2021 00:170 using format string yyyy-MM-dd HH:mm:ss for field start_date

Thanks

[Sai Kumar B]

@Tara 

You might be importing a date into a date/time field. In your transform map, go to the source_field_name field mapping. There should be a field on the left side of the form called 'Date Format'. You should see a list of date formats. Choose the one that matches your data. Reprocess the import set and transform. 

Failing that, you can just hardcode the fix by adding a time onto your string. Check source script and use something like this:

var date = source.source_field_name.toString();
answer = date + "00:00:00";

[Ankur Bawiskar]

Hi,

what is 00:170?

14/08/2021 00:170

Regards
Ankur

[Tara16]

by mistake 170. I have tried with correct numbers. It is not working. I have changed the date format in transform map too.

[Ankur Bawiskar]

So how does the incoming data look like?

14/08/2021 10:20:45

i.e. dd/MM/yyyy HH:mm:ss

Regards
Ankur