If your dates are real dates, you could rightclick on the Date field (In the
pivottable) and choose "Group and show detail".

Then you could group my month (or month and year).

Another option might be to use another column of formulas:

=text(a2,"yyyy-mm")

And use that in the pivottable.

BorisS wrote:

I have a date field in my pivot table, for which source data not only has the
year, but also the time. When I get it into the pivot table, however, there
is no way I can figure out to get it to show me (both in the dropdown for
selection of range or in display of the labels) the date with the year. As
such, because the data spans several years, it's hard to guess which dates to
include and eliminate in order to capture any particular month of a
particular year. Any clues? I know I have no blanks in there, which
sometimes throws date fields off. I know my source is formatted to date
format. I don't have any other ideas of what to try.

Thanks for any help.
--
Boris

--

Dave Peterson