How to extract January from month(date) (97)

Topic

New Reply

If month(date) returns 1, how would I get

Reply | Quote

Replies

Take a look at the Choose function in the builtin help.

choose(month(date),”January”,”February”,…)

Reply | Quote

=Format([yourdate],”mmmm”)

Reply | Quote

Oops! Since I don’t play with dates very much I didn’t remember the simpler solution. I use Choose a lot for other purposes – real handy for turning 1, 2, 3… into whatever strings you want.

Reply | Quote