Date Field

[stevezap]

Hello,

I have a csv file with a column of dates that I am trying to input.  When I use the select function and set the type to DateTime I get an error message "[date] is not a valid DateTime".  I've tried DataTimeParse but that doesn't seem to work either.  When I open the csv in Excel it recognizes the column as a date field "m/d/yyyy h:mm" and I can do formulas on the field no problem (month(), year(), etc.).  Is there a way taht I can get the column into Alteryx as a date?

Thanks for the help.

[ChrisTX · Accepted solution]

Is your date column being imported as a string field?  DateTimeParse in a Formula tool should work.

DateTimeParse([Your Date Field], "%m/%d/%Y %H:%M")

Chris

[stevezap]

Thanks!  I had it as a V_String, but changing it to String now works.

[ChrisTX]

Data type String or V_String should work the same.  Guessing there was a syntax issue with your DateTimeParse.