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.
Solved! Go to 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
Thanks! I had it as a V_String, but changing it to String now works.
Data type String or V_String should work the same. Guessing there was a syntax issue with your DateTimeParse.