Splicer vs Filter different results

[Davidm54]

So I have a client list with dates....

Full list of dates, no filter

Copied column with dates changed to Months for filter

When I filter with Splicer, single dates appear, not all of that month.

Filters correctly if I use the Filter in table.

Unsure why. Seems that the splicer actually only hunts for the first instance of the actual date and filters by that.

Any ideas if I can fix this or am I going to have to create a formula column to sort months properly?

[#2]

@Davidm54 This seems to have been around since Slicers where introduced. Slicers on tables don't work very will with dates. The attached article describes the issue and the workarounds.

 https://www.myonlinetraininghub.com/sorting-excel-date-slicers 

[#3]

Thank you. hmmm, that poses me some issues. custom lists isn't an option given who needs to access this, and I can't remove the original dates as they're the important bit that needs to be seen.

Creating the second column with custom formatting was what I have done already, and that's what is not working, it's going to single lines instead of all feb-21s for example.

Hmmmmmm.

[#4]

https://exceljet.net/formula/get-month-name-from-date

Non-ridiculous formula to end up with same result. This works for me, and will allow the dynamic data to still update fine.