Pivot Table Date Filter Issue

[Harribone]

Hi,

When using a field under filters that contains dates (numbers format as dates, no text etc) the data is not grouped by year/month when you go to apply a filter.
Am I missing something obvious?

Thanks in advance
Harribone

[Bo_Ry]

Put date to Rows > right-click > Group

Day, month, year will be available to select

Group.png