file name "ddmmyy" to Date Format - unusual date formats

Hi Everyone,

I have report generated each day and it's name contains date as of when the report is generated. Basically the file name is always "ddmmyy". I have stuck how to convert it to date, most likely the date format yyyy-MM-dd which Alteryx Designer prefers.

I dig for solution and similar subject queries but I couldn't find this specific type of converting from "ddmmyy" as a string to "yyyy-MM-dd" as a date

Any ideas will be very welcomed!

Custom Tools

Date Time

Transformation

Accepted answers

atcodedog05

Hi @DanielCh

You can use formula like below

DateTimeParse(ToString([File date]),"%d%m%y")

Workflow:

Hope this helps : )

file date.yxmd

Jean-Balteryx

Hi @DanielCh ,

Here are two ways to format date using either DateTime tool of Formula tool with DateTimeParse() function :

Capture d’écran 2021-08-16 à 11.22.03.png

Workflow attached ! Tell me if you have any question !

format_dates.yxmd

All comments

atcodedog05

Hi @DanielCh

You can use formula like below

DateTimeParse(ToString([File date]),"%d%m%y")

Workflow:

Hope this helps : )

file date.yxmd

Jean-Balteryx

Hi @DanielCh ,

Here are two ways to format date using either DateTime tool of Formula tool with DateTimeParse() function :

Capture d’écran 2021-08-16 à 11.22.03.png

Workflow attached ! Tell me if you have any question !

format_dates.yxmd

DanielCh

Thank you both for the quickest response ever. This community is the best 😉 ! Personally I used formula tool but this is exciting that CUSTOM option in DateTimeTool give big possibilities as I see. Work for me as well.

Thanks,

Daniel

atcodedog05

Happy to help : ) @DanielCh

Cheers and have a nice day!

Jean-Balteryx

Happy to help @DanielCh ! 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703