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

Date Time

Accepted answers

ChrisTX

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.

Screenshot 2024-08-22 101031.png

Chris

Extract Date from Directory Filename.yxmd

All comments

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

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.

Screenshot 2024-08-22 101031.png

Chris

Extract Date from Directory Filename.yxmd

KamenRider

Thank you!

Kamen

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280