Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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