[Bug]: Date/datetime columns in table are sorted alphabetically as text, instead of as proper date/time

[martkaczmarek]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

When sorting table columns with data of type datetime, sorting is done alphabetically on formatted, displayed text, instead of on the actual value:

Expected Behavior

Columns containing datetime or date type of data should be sorted with relevant function, not alphabetically as displayed text

Steps to reproduce

1. Create a table with the following example data:

[
{date:"1999-01-28T15:52:23Z"},
{date:"2025-03-01T15:52:23Z"},
{date:"2040-05-23T15:52:23Z"}
]

2. Make the date column type of datetime, and make it sortable and enter the following formatting: DD.MM.YYYY
3. Sort the data ascending or descending - data is not sorted correctly

Environment

Docker compose multi-image, v2.5.2

Additional Information

No response