Invalid date range when choosing to display DD/MM/YYYY instead of YYYY/MM/DD

English Forum Issue Report
1

Hello,

* Describe the bug

Incorrect date range value when choosing to display DD/MM/YYYY instead of YYYY/MM/DD; it reverses the days and months when selecting.

* Environment

  • NocoBase version:

v2.0.0-alpha.62

  • Database type and version:

postgres psql (PostgreSQL) 16.3 (Debian 16.3-1.pgdg120+1)

  • OS: MacOS Monterey 12.2.1

* How To Reproduce

Create a date range field with the setting DD/MM/YYYY in a view. Add the field and make a selection in the date range. The values that will be used will not be correct.

Expected behavior

the operation should be the same as with MM/DD/YYYY

Screenshots

my select 01/05/2026 → 08/01/2026

Capture d’écran 2026-01-08 à 10.53.35
Capture d’écran 2026-01-08 à 10.53.352482×994 274 KB

after click the value are wrong

Capture d’écran 2026-01-08 à 10.53.42
Capture d’écran 2026-01-08 à 10.53.422494×820 99.4 KB

Thank you in advance

2

Please upgrade to the latest version and check if the problem persists.