Date Field Conversion Error

I have a CSV dataset with a single date column in the mm/dd/yyyy format. When the data is loaded into the designer it is assigned the type - string. I have used the select tool to convert it to date. However, I am running into an error that says Date: "1/15/2015" is not a valid date. And the same errors is shown for a total of 11 dates from the entire dataset.

I have tried using datetime tool as well but that did not work too. What could be the possible solution?

Date Field Conversion Error.PNG

Date Time

Accepted answers

The issue is the date is not in expected Alteryx Date format.

Expected Date Format by Alteryx is yyyy-MM-dd

You can use datetime tool to convert it. Here is a handy resource 🙂

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-DateTime/ta-p/38302

Your expression in datetime tool would be MM/dd/yyyy

Hope this helps 🙂 Feel to ask if you have any questions

What's the configuration you've used in the datetime tool? If you configure it as shown below, I think that will solve the issue

Screenshot 2020-11-24 143959.jpg

Let me know if that worked for you,

Cheers

Angelos

All comments

The issue is the date is not in expected Alteryx Date format.

Expected Date Format by Alteryx is yyyy-MM-dd

You can use datetime tool to convert it. Here is a handy resource 🙂

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-DateTime/ta-p/38302

Your expression in datetime tool would be MM/dd/yyyy

Hope this helps 🙂 Feel to ask if you have any questions

What's the configuration you've used in the datetime tool? If you configure it as shown below, I think that will solve the issue

Screenshot 2020-11-24 143959.jpg

Let me know if that worked for you,

Cheers

Angelos

It worked. Thank you so much.

My earlier config was custom and I tried keeping it in the mm/dd/yyyy format but this one worked out. Thank you.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703