Date is not a Date

[TeamTJ]

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?

[funmiOdem]

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.