Transform map not mapping date field correctly

[kim-lindgren]

I have an Excel file with dates that I want to upload to a table. The date format in Excel is yyyy-MM-dd. After auto-mapping all fields I followed this instruction to update the field map for the date field.

It was yyyy-MM-dd HH:mm:ss but I changed it to yyyy-MM-dd.

After I run the transform, all fields map correctly except for the date fields. The error says that the format is still yyyy-MM-dd HH:mm:ss!

I have tried this multiple times now but I always get the same error. Any help appreciated.

[Ahmed Drar]

Hi @kim-lindgren , 

There is a very good article in support explaining how to map date value correctly in a transform map

here is the article 

 https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0955636 

I hope this helps.

Ahmed

Please mark my answer as Correct / Helpful based on the Impact

Community Rising Star 2022

[kim-lindgren]

Thank you, unfortunately it still doesn't work.

I changed all the Excel dates to text fields and exported again. But there is no difference: this is what the field map for 'u_date' looks like in the transform map. I don't know if it should convert it to a date, but it does. I changed the date format again but still get the exact same error...

[kim-lindgren]

This is actually really strange. I looked at your link again and it says to ensure the date field in the imported data is set to string. So I uploaded it again (third time) and this time the date field really has type string - and still no difference when I transform! 

[dragoonizzaha]

So that's it?