Date format required : MM/DD/YYYY

Question

Hello,

I have a column name Date which is yyyyymmdd format. I would like to change format to MM/DD/YYYY. Tried with few steps, but still not getting proper answer.

Can anyone please help

AngelosPachis · Accepted Answer

Hi @Karthick461 ,

You should first convert it to a date format within alteryx and then to a mm/dd/yyyy format. Here's an example how you can do it

philipmannering · Accepted Answer

Though I prefer @AngelosPachis method, an alternative would be to use the Regex Tool,