Getting error trying to "group" by Day, Month and Year on a pivot table

Hi,

Below is the code i am using to try and group by day, month and year using vba for a pivot table. But its giving me an error. I cant publish the entire file as it is too big and has "sensitive" data in it.

Please Login or Register  to view this content.

I think the issue with the "text" .LabelRange.Group but i am not sure.

Any ideas?

Run-Time Error: 1004
"Group method of Range class failed"

and it errors out on this line of code

".LabelRange.Group Start:=True, End:=True, Periods:=Array(False, False, False, True, True, False, True)"

yes and when i record it i get this

Please Login or Register  to view this content.

anybody know?