Skip to content

Viewing date in column 1 day off from date entered #2705

Description

@iitopher85ii

Steps to reproduce

  1. Create table
  2. Create date only column (not time and date, just date when adding column)
  3. Create row entry, enter date

Expected behavior

Date shown to be selected date

Actual behavior

Date shown in table view is 1 day less (example: "Jun 26, 1985" instead of selected 1985.06.27), but clicking on date to edit or clicking 3 dots/meatball menu and "Edit row" shows correct date in the field/picker (1985.06.27).
(Also shows 1 day less for other dates unless editing, too, not just the example date)

Tables app version

2.2.0

Browser

Brave 1.90.128 (Official Build) (arm64) Chromium: 148.0.7778.217

Client operating system

macOS Tahoe 26.6

Operating system

AlmaLinux 9.8 (Olive Jaguar) (Linux 5.14.0-687.5.4.el9_8.x86_64 x86_64)

Web server

Apache

PHP engine version

PHP 8.3

Database

PostgreSQL

Additional info

Nextcloud AIO latest (just updated), Nextcloud Hub 26 Winter (33.0.3).

date and time (instead of just date) appears to work correctly, just the columns where date only is set is where this odd issue is observed.

happens when either entering manually or using api to add row, right value is input, 1 day before is shown, unless editing.

Metadata

Metadata

Assignees

No one assigned

    Labels

    0. Needs triagePending approval or rejection. This issue is pending approval.bugSomething isn't working

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions