Extract Date from Directory Filename

[KamenRider]

Hi,

Can someone help me extract the date and convert this to this date format, "mm/dd/yyyy".

Filename: time_mist 20240822.xlsx.

Thanks,

Kamen

[shancmiralles]

i just use the data cleanisng tool and  check all unwanted characters aside for "Numbers", this should just show the number parts (which is the date)..
then date time tool should help you ... select the format that matches the incoming field ( yyyyMMdd).. 

[ChrisTX · Accepted solution]

See attached workflow

The date format "mm/dd/yyyy" must be stored as data type String.

If you want data type Date, Alteryx will always store and display it as YYYY-MM-DD.

 

Chris

[KamenRider]

Thank you!

Kamen