Change the string to Date format

[nirvapatel1998]

Hello, 

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

Input: yyyymmdd

Output: mm/dd/yyyy

TDATE	OUTPUT
20220221	02/21/2022
20220126	01/26/2022
20230221	02/21/2023
20230103	01/03/2023

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

Thank you. 

[alexnajm]

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

[binu_acs]

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