I am pulling data from a SQL Server database and have a field called Date. It is a VarChar50 field.
I am needing to convert it to a Date field, but I am getting this error when using the select tool to convert it:
Date: "05/01/2019" is not a valid Date
It throws this error for every line, but those are all valid dates.
Suggestions?
Solved! Go to Solution.
I just started using Alteryx (inherited at a new job that I am at), and all I can say is that it is krapp. Fortunately for me, I have been given the green light to switch to something else. I am more familiar with PowerBI, R and Pandas and I am switching to those.