date format helpppppppppp

[hi2019]

Ok

So I got it to 2020-12-30 with datetimeparse from 20201230m but I want this string to date in the below format now - is it like a 2 step thing?like first datetimeparse then date timetool? its so time confuming for something so simple!

MM/DD/YYYY  what do I do? 

plx help thanks!

[ChrisTX]

If you want the final data type to be Date, it will displayed as YYYY-MM-DD in Alteryx.

If you want it displayed differently, it must be a String data type.

What is your original data type and format (if not a Date)?  Destination data type?  Destination format?

A few examples of input and output would help.

check out DateTimeParse and/or DateTimeFormat

List of functions:  DateTime Functions (alteryx.com)

Chris

[binuacs · Accepted solution]

@hi2019 use the formula tool to convert the date from yyyymmdd tp mm/dd/yyyy