Pivot Grid - Sorting dates in Long Date format is alphabetical, not numerical/date

[edhans]

Description

We have our Date formatted as Long Date in the date table. The Pivot Grid is sorting it alphabetically.

You can see that May is coming after July here.

Once we change it back to a normal date format without words in it, like dd/mm/yyyy, it sorts properly.

This might be related to some degree to #1318 in the sorting code.

Tabular Editor 3 Version

3.16.2

Screenshots

No response

Steps to Reproduce

No response

Expected behavior

I would expect it to sort in the underlying date order regardless of the date format, even if it is a date format with words in the display.

Crash Report

No response

Windows Version

11

[mlonsk]

Hi Ed
Thanks for reporting this, we are looking into it

[mlonsk]

Hi @edhans
We have identified the bug and will get it fixed in a future update.

The alphabetical sort happens regardless of the Format of your dates—it is the ascending/descending sort order that triggers it.
The issue also exists on integers which are also sorted "Alphabetically".

Here are few pictures confirming the issue:

The short date format is sorted alphabetically:

Long date without explicit sort looks correct:

Explicit sort on long date:

Integers also sort alphabetically.