How to get the month name instead of month number

[dwright]

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]

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]

@dwright

I need text January, February, etc.?

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