How to get the month name instead of month number

dwright · October 15, 2025, 2:52pm

how do i convert the month number to month name in a formula - right now its <month({Date1}) > it gives me the month but in number format and I need text January, February, etc.?

rdb · October 15, 2025, 7:30pm

Please use the switch() function.

switch(weekday({Date1}), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, 7, “Saturday”, “no match”)

Julia · October 22, 2025, 6:51am

Yes, you can use switch() function to get month name. This is my example:

switch(
  month({time}),
  1, "January",
  2, "February",
  3, "March",
  4, "April",
  5, "May",
  6, "June",
  7, "July",
  8, "August",
  9, "September",
  10, "October",
  11, "November",
  12, "December",
  "no match"
)

Here is the month result