nextcloud / nextcloud/tables

Viewing date in column 1 day off from date entered

Open
#2,705 1 comment 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

0. Needs triage bug
Dominant language
JavaScript
Stars
214
Forks
52
Avg merge
1d 10h
Merged PRs (30d)
82

Description

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.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Reproduce the issue with a date-only column and compare the table view with the edit field or picker, including dates entered manually and through the API. Trace the date-only display path in the Tables app and check existing tests around date rendering. Done means the table shows the selected date consistently without changing the behavior of date-and-time columns.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript
Domain
frontend
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
68/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.