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 would like to covert say 20171026 to 26/10/2017 in AlteryX. I tried the DateTime tool and got the error "ConvError: DateTime (643): DateTime_Out: Cannot convert "20171026" to a date/time with format "%d/%m/%Y": Expected separator '/%m/%Y', got: '171026' Record #1.
Not sure exactly how you are going about this but I would Convert the 20171026 to a string and then use the DateTime tool to convert it to a Date in standard alteryx format. Then use a formula tool utilizing the DateTimeFormat() function. Example workflow attached.
@gundam_pilot Here’s one approach… if the field type is a string, you can use the DateTime tool to convert the string to the Alteryx date format (incoming format = yyyyMMdd). Then use another DateTime tool to convert the date to the dd/MM/yyyy format.