Solved: Easy way to group date in Pivot Table

[Djblois]

Anybody know an easy way to group the date in a Pivottable with VBA? Right now all I can find is I have to select the column name or one of the dates and then group it. Is there an easier way?

Daniel

[matthewspatrick]

This appears to work:


Dim pf As PivotField

Set pf = pt.PivotFields("Date")
pf.LabelRange.Group Start:=7306, End:=73051, Periods:=Array(False, False, False _
, False, True, False, True)


In my limited testing, that grouped my date field into years and months, with really wide boundaries for the start/end dates.

[Djblois]

Thank you that worked perfectly