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

[DanielCh]

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! 

[atcodedog05 · Accepted solution]

Hi @DanielCh 

You can use formula like below

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

Workflow:

Hope this helps : )

[Jean-Balteryx · Accepted solution]

Hi @DanielCh ,

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

Workflow attached ! Tell me if you have any question !

[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 ! 🙂