Skip to content

Copying and pasting a date between two US-format date fields silently swaps month and day #5870

Description

@dimmur-brw

Describe the problem

When copying a date value (Cmd/Ctrl+C) from one date field and pasting it (Cmd/Ctrl+V) into another date field - both configured as US format (MM/DD/YYYY) - the pasted date is silently reinterpreted as European format (DD/MM/YYYY). No error is shown; the result is a valid but incorrect date.

Steps to reproduce and actual result

  1. Create a table with two Date fields, both set to US date format (MM/DD/YYYY)
  2. In Field A, enter the date 01/10/2026 (January 10th, 2026)
  3. Click on Field A's cell to select it, then press Cmd+C (or Ctrl+C)
  4. Click on Field B's empty cell and press Cmd+V (or Ctrl+V)

Actual: Field B shows 10/01/2026 (October 1st)

Expected result

Field B shows 01/10/2026 (January 10th)

Environment

No response

Metadata

Metadata

Assignees

Labels

database 🗄️Key expertise in database is required, though the issue may also involve domain::core.

Type

Projects

Status
In Review

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions