Date conversion not working from String

Question

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 Answer

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?