[Bug] Date format not respected in date type for datagrid

[philiprenich]

Bug Description

My AppFlowy app is set to D/M/Y format. When I type in the date 2/9/2025 in a datagrid date field, it selects February 9th, 2025, not September 2nd, 2025. The format in the input seems to be forced M/D/Y. It only works correctly if the D portion is above 12.

How to Reproduce

Try putting a date into a date field that uses a day and month below 12.

Expected Behavior

Respect the Date format I've selected for the app.

Operating System

MacOS

AppFlowy Version(s)

10.0.2

Screenshots

No response

Additional Context

No response

[LucasXu0]

It can be reproduced in the latest version.

[annieappflowy]

Fixed in the upcoming release (0.10.7)