Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Field Conversion from string to Date

NISHA_373
7 - Meteor

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

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor

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. 

Labels
Top Solution Authors