Converting Numerical Months Into Month Names

ztrean · August 26, 2020, 7:14pm

I have an integer column that represents months (so 1-12) and I was wondering if there was a way I can convert that to month names?

Ryan · August 26, 2020, 7:15pm

Hey Zachary!

Definitely! You’ll want to use the choose function for this!

The formula would work like this:
Choose([Month],“January”, “February”, “March”…

system · October 15, 2020, 3:47am

system · October 28, 2020, 9:18pm

system · November 13, 2020, 9:38pm

system · December 3, 2020, 10:06am

system · December 22, 2020, 10:19pm

system · January 12, 2021, 2:09am

system · February 1, 2021, 10:15am

system · February 22, 2021, 8:10pm

system · March 16, 2021, 6:15am

system · April 6, 2021, 8:13pm

system · April 28, 2021, 10:12am

cvoekel · May 17, 2021, 12:11am

I can’t get that function to work; it throws a “expecting EOF” error

Ryan · May 19, 2021, 6:54pm

Hey Carter,

Did you copy and paste this into your formula bar? If so that could be throwing the error. Can you try typing it out manually?

system · June 11, 2021, 1:51am

system · July 3, 2021, 10:38pm

system · July 26, 2021, 3:15pm

system · August 18, 2021, 11:30am

system · September 10, 2021, 11:30pm