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

Formula to create month names

skeen503979
8 - Asteroid

Hello, 

 

I need help creating a formula to generate a new column with the name of the month as the output.  I don't want the new column to contain the day or year or anything else.  I just need the name of the month.  I've read through https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm, but can't seem to find an easy way to output only the name of the month.

 

Thoughts?

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor

Hi @skeen503979 you can use the formula datetime format to get the Month name. This link has the list of specifiers you need to use.

 

Datetime_07052021.JPG

Labels
Top Solution Authors