Field Conversion from string to Date

[NISHA_373]

When I am converting my date column data type from string to date through select column, all the values becomes null. How can I convert my date field which is of string data type to date data type

[JosephSerpis]

Hi @NISHA_373 Alteryx only recognises dates in the ISO format YYYY-MM-DD if your dates are in any other format then Alteryx will see that as a string type. Therefore if you convert the data type to a date data type before you do this then the fields becomes null. You will need to convert your date format from it's current format into YYYY-MM-DD. You can do this with a Date Time tool or with a formula in a formula tool using Datatimeparse.