community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Date is not a Date

Highlighted
Meteor

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?

Alteryx
Alteryx

@TeamTJ  you can use the datetime tool in the parse category to format the field into an Alteryx Date format YYYY-MM-dd

 

Best,

 

Jordan

Meteor

Thank you!!

Meteor
You can also cast that field as date, from your sql syntax.

see cast function for more information:

https://www.1keydata.com/sql/sql-cast.html
Labels