How to insert a column month

Feature requests
, ,
1

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

2

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:

SWITCH(MONTH({Date}),1,“January”,2,“February”,3,“March”,4,“April”,5,“May”,6,“June”,7,“July”,8,“August”,9,“September”,10,“October”,11,“November”,12,“December”,“”)

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

Mark

3

@mark.anley @Solplanet

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

FORMAT_DATE({Date}, "MMMM")

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

1 Like
4

Oh! So close…so very close…
Mark

1 Like