This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have searched this Knowledge Center for days and still cannot figure out how to format a column which is in a Decimal format (20170131) to a date format (1/31/2017) or ANY date format for that matter. I cannot figure it out. Alteryx will not allow me to change the format to string or anything else. I know this cannot be that hard but I have wasted way too much time trying to answer.
Thanks jdunkerley79 for the reply. I tried that numerous times/ ways and it would not let me go from decimal to string then to date. I may have found a solution by first LEFT([CREATE_DATE],4)+'-'+SUBSTRING([CREATE_DATE],4,2)+'-'+RIGHT([CREATE_DATE],2) my date into a string then I can easily change this to a date. I am still working it but it looks like I may have a solution. Thanks.