Bases: Date Property Columns Sort Unexpectedly/Incorrectly

Steps to reproduce

Create several files with a shared date property and include a variety of dates across several years, including a few dates with the same month. Eg. 02/15/2023, 02/25/2024, 05/01/2025

Insert a new base and limit to the files where the date property is not empty.

Add the date property as a column if it’s not already, and click the column header to sort by that date property.

Did you follow the troubleshooting guide? [Y/N]

Yes

Expected result

The rows of the Base view being displayed in ascending then descending order by date chronologically, from oldest->newest / vice versa.

Actual result

The rows of the Base view are displayed in ascending then descending order numerically by month.

Environment

SYSTEM INFO:
Obsidian version: v1.9.1
Installer version: v1.6.5
Operating system: Windows 11 Home 10.0.26100
Login status: logged in
Language: en
Catalyst license: insider
Insider build toggle: on
Live preview: on
Base theme: adapt to system
Community theme: none
Snippets enabled: 0
Restricted mode: on

RECOMMENDATIONS:
none