Cannot convert string to datetime format

[mystasz]

Hi Community,

I have a column that is in V_String format and looks like the below:

2018-07-31
2018-04-17
2018-07-26
2021-04-04
2018-04-05

I used the DateTime tool and selected String to Date/Time format. The custom logic I used is %Y-%m-%d.

I get the following error: 

ConvError: DateTime (38): Date_Out: Cannot convert "INVOICE_DATE" to a date/time with format "%Y-%m-%d" and language "English": Expected a number for year: 'INVOICE_DATE' Record #623054

ConvError: DateTime (38): Date_Out: Field Conversion Error Limit Reached

I've tried a bunch of combinations and am having no luck. 

[IraWatt]

Hey @mystasz,

Can you send a screenshot of your tool config and the error? I cant replicate this no matter what I put into the DateTime tool.

[IraWatt]

@mystasz, Also just realised the error says which record is your issue, have a look at Record #623054 it will be what is causing this, will be interesting to know what it looks like.