I am having trouble starting my pivot table data from the first of the current month. The "Now" function is too specific. I also have tried Month(now) but that doesn't work. Here is what i have:
![]()
PT.PivotFields("DueDate").LabelRange.Group _ Start:=Now, End:=True, Periods:=Array(False, False, False, _ False, True, False, True)
Bookmarks