Date conversion not working from String

[TeamTJ]

I have a .csv file with dates in it and I'm trying  to do some math with them but I am getting the error:

"Cannot convert "9/22/1998" to a date/Time with format  "%d/$m/%y"

My dates are coming in like this:  "01/06/2004"

My select tool, immediately after my Input Data tool shows my dates as V_WString

I'm using a DateTime tool to try and convert those strings to dates.

Nothing seems to be working.

Any advice?

[LordNeilLord · Accepted solution]

Hi @TeamTJ

It's because 9/22/1998 is in the format %m/%d/%y

Are you sure your other dates are dd/mm/yyyy?

[TeamTJ]

Obviously I don't know the difference between a day and a month,,,ugh!

And I've been staring at that for 30+ minutes.

Thanks for the help...and for not mocking my ignorance!