How to insert a column month

How can I add a MONTH column to my board with output as the name of month ?

Hi @Solplanet - I figured FORMAT_DATE({Date}, “mmmm”) would work but it returns 0000.

The longer way around would be to create a formula column with a simple switch statement:


@JCorrell - there must be a more efficient way than this :slight_smile:


@mark.anley @Solplanet

You were very close. When formatting dates/times “M” refers to the month, “m” refers to the minute.
Try this:


Jim - The Monday Man
:magic_wand: Column Magic :sparkles:- the magical columns toolbox app

1 Like

Oh! So close…so very close…

1 Like