We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Excel Output, Name With Month and Year

neromerob
10 - Fireball

Hello to everyone. 

 

I have done a workflow where my final output has a name like this: 

 

Output_07_06_2022

 

the formula that I´m using to accomplish that is the following. 

 

"C:\\Output_"+DateTimeFormat(DateTimeNow(),"%d_%m_%Y")+".xlsx|TAB1"

 

formula_fecha.JPG

 

but What I need is the file with a name like this 

 

"Output – Month 2022" by month meaning  by name and not by number (May, June, July) 

 

Thank You. 

 

 

2 REPLIES 2
CarliE
Alteryx Alumni (Retired)

Hi @neromerob 

 

The formula should be this: 

 

"C:\\Output_"+DateTimeFormat(DateTimeNow(),"%B %Y")+".xlsx|||TAB1"

 

Please mark as a solution if this solves your issue to help other community members out!

Carli
neromerob
10 - Fireball

thank you it worked

Labels
Top Solution Authors