Date format required : MM/DD/YYYY

[Karthick461]

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 solution]

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

[binuacs]

@Karthick461 Another option using formula tool

Spoiler

[PhilipMannering · Accepted solution]

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