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?
Solved! Go to 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?
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!