Forum Discussion
Sina1
Jan 02, 2026Copper Contributor
Unable to use group the pivot table with date
I was unable to group the Pivot table with date selected. I've validated the format of the date and numbers as well.
SergeiBaklan
Jan 06, 2026Diamond Contributor
In addition, validate values, not formats. If you have texts which looks like dates and apply date format to such texts - values will remain texts, applied format changes nothing.