MonthName

[oaishm]

I made a field:
=MonthName(Month([Month]),true)

and it works fine in access.

Then I linked it in Excel 2007 and I get the error Undefined function MonthName in function. It looks like I'm forced to use the access pivot table. Terrible.

 

[Norie]

Why not use Format instead of MonthName?

You would need to use a date field though.

Where/when exactly are you getting the error?

When you import the data to Excel?

If the data is for a pivot table couldn't you just use the grouping functionality available for dates etc in Excel?

 

[oaishm]

The pivot tables can only group dates with no year month day hierarchy. Then I tried to make my own hierarchy by putting it on access. That works with the month function, of course, but not monthdate, which spells out the day of the month. Crystal does it quite nicely. But alas. Crystal does a lot of things nicely.

Oh yes, of course I can't just pass a date over because excel can't handle the grouping.

 

[Norie]

What do you actually have?

A date, a month?

 

[xenou]

1)

Pivot tables can group by months (and days, weeks, quarters, years etc.) ...
See here for more:
http://www.mrexcel.com/articles/pivot-table-group-dates-by-month.php

I'm not saying I'm the world's biggest fan of pivot tables but it might meet the need and some things they do quite handily.

------------------------------------------------------

2)

As noted by Norie, you probably could also use the format function for this (which is an inbuilt vba function and should travel well):
=Format([FieldWithDate],"mmm")

------------------------------------------------------

I'm not sure but MonthName might be an Excel formula too, which could account for the conflict working in an Excel environment (most VBA functions are not available in Excel when they have direct Excel counterparts).