Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

DanielCh
7 - Meteor

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! 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @DanielCh 

 

You can use formula like below

 

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

 

 

Workflow:

atcodedog05_0-1629105849660.png

 

Hope this helps : )

Jean-Balteryx
16 - Nebula
16 - Nebula

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 !

DanielCh
7 - Meteor

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
22 - Nova
22 - Nova

Happy to help : ) @DanielCh 

Cheers and have a nice day!

Jean-Balteryx
16 - Nebula
16 - Nebula

Happy to help @DanielCh ! 🙂

Labels