That's not going be any help when I try to group my documents by month.
They're creating list items with a "Date" field and there's so many of
them, they want them grouped by month.
No sweat, I thought, I'd just calcualte a column from the date field
using Month([Date]) which returns an integer. So I'd like to convert
the integer to a meaningful string like "August."
So try to If(Month([Date])=1,"January",If(Month([Date])=2,"February
and so on and you'll get barfed on at 8, i.e. August.
Which would work fine if we were getting done on time i.e. June.
So who's got the great trick to group these items by month?
Do I have to get the creator to enter the month on the item itself?