Date formatting returning all null values

[jb]

Hopefully an easy fix, but even though I've formatted by date column in excel as date and used a select statement in Alteryx to again classify it as a date, all date values are coming back as null. Does anyone have experience with this?

Thanks!

[MarqueeCrew · Accepted solution]

Are the dates in the format yyyy-mm-dd?

Sent from my iPhone

[jb]

That solved it, thanks! Had it formatted as mm/dd/yyyy

[jb]

@MarqueeCrew I've been reformatting the dates in excel prior to inputting the data to Alteryx, but is there a way to do the reformatting in Alteryx? Dates are originally in mm/dd/yyyy format.

[AndrewW]

Try the DateTime tool in the Parse section - it can convert a string date to an actual date. http://downloads.alteryx.com/Alteryx9.0/WebHelp/datetime.htm