How do I set date time fields in Dynamics 365

How do I set date time fields in Dynamics 365 from a date time string in a CSV. (eg 10-12-18) . When I manually type it as "10-12-18" it works, but when I use the CSV field it doesn't. 

 

I have tried DATETIME() with DATEPART but it keeps saying it's in the wrong format.

 

Operation failed. Label: Update/Insert xxx_component, Name: xxx_componentUpdateInsert, Message: 15:Unable to format the data '‭11-10-18‬' for ymi_component.xxx_production_date. String was not recognized as a valid DateTime. : Error in calling Operation Update at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value, IFormatProvider provider) at Scribe.Adapter.Crm.DataAccess.ConvertData.ConvertMinDateTime(Object dateValue, DateTime crmMinDate) at Scribe.Adapter.Crm.DataAccess.ConvertData.ToCrmValue(KeyValuePair`2 attributeData, String entityName, FieldDefinition fieldDefinition, Dictionary`2 entityData, Version apiVersion, EntityDefinition entityDefinition)

Anyone that ran into this before?

Login