Start Free Trial

Alteryx Designer Desktop Discussions

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

change month order

Ar13f
10 - Fireball

Please assist me; I'm trying to create a report similar to the one below, but the outcome isn't what I'm looking for:

 

P1.png

 

 

 

 

 

I'm looking for the following result, I want the header for the month as below:

 

P2.png

 

please help and advice, I have attached it to the workflow.

11 REPLIES 11
Ar13f
10 - Fireball

Dear @atcodedog05 

 

thank you very much for your advice and help ... it seems I really have to learn a lot in this community especially for regex functions (reply message from @cmcclellan) and formulas like this "DateTimeFormat(DateTimeParse([_CurrentField_],"%Y_%m_%d"),"%b-%Y")"

 

 

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Ar13f 

Cheers and have a nice day!

Labels
Top Solution Authors