I've implemented a Pivot Grid in an application and noticed that the date format doesn't follow the localization (in this case French).
The dates will always be displayed in [MM/dd/yyyy hh:mm:ss]
After some research, I've created a DateTimeGroupDescriptor to fix the displayed format.
However, it breaks the "Label filter" option (ex: when filtering with "is greater than 01st Jan 2019", it still displays 2011 entries).
If I don't use the group descriptor, it works fine.
How can I fix this? (my goal is to display the dates in the following format [dd/MM/yyyy] while preserving the Label filter option)
By the way, I'm using the latest R1 2020 SP1 update.
Let me know if you need more information.
Side note: when using the UI culture fr-FR, the sorting label is incorrects
It says "Classer de A à Z" for "Sort Z to A" instead of "Classer de Z à A" ;)