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

dd.mm.yyyy to mm.yyyy

RDF25087
8 - Asteroid

Hi all -

 

I have a data set with the date format of dd.mm.yyyy - for my reporting requirements I only need the data by month not day, so need to convert the date to mm.yyyy. How can I do this please?

 

Thanks

RDF

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @RDF25087 

 

The quickest way is to use right() function like below.

 

Workflow:

atcodedog05_0-1632476946955.png

 

Hope this helps : )

RDF25087
8 - Asteroid

Thank you @atcodedog05

 

That seems to work. I just needed to add a DateTime function after your solution to ensure it was in a date format.

 

RDF

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @RDF25087 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!

Labels