Change the string to Date format

Question

Hello,

Can someone help guide on how I can change the string format of date to date format.

Input: yyyymmdd

Output: mm/dd/yyyy

TDATEOUTPUT20220221

02/21/20222022012601/26/20222023022102/21/20232023010301/03/2023

TDATE is my input and OUTPUT is the output I am expecting. The data type for OUTPUT should be "Date"

Thank you.

binu_acs · Answer

@nirvapatel1998 One way of doing this. as @alexnajm said mm/dd/yyyy is not a valid date format in Alteryx

DateFormat_210223.yxmd

alexnajm · Answer

Hi @nirvapatel1998,

for clarity, Alteryx only stores dates as a Date data type in the ISO format - YYYY-MM-DD. If you want it to be formatted as MM/DD/YYYY coming out of Alteryx, it will have to stay as a string. Is this alright?

Otherwise if you want to store it as a Date ans indicated, you can change the display format on the Excel side if you want it to stay as a Date data type in Alteryx.

-Alex