Bug: days() formula in basic table in universal app

User Talk Apps
1

Your Setup:

  • SeaTable Cloud

Describe the Problem/Error/Question:

The values in a formula column of the basic_table diagram in the dashboard page of the universal app, have a discrepancy to the values within the table of my base.

I have a table with 3 columns

  • Start (Date)
  • End (Date)
  • Days (Formula)

The formula is: days({Start}, {End})

If Start and End pass the date 29.03.2026 to 30.03.2026 the days are displayed correctly in my table. However when I use the “Basic_table” statistic diagram in the universal app the column shows 1 day less, than in my table.

I have tried this with a lot of dates and it seems to happen only with these specific dates. I have also reconstructed this in a completely fresh base and the same error occured again.

Table in base:

image
image1015×111 6.57 KB

Basic_table diagram in dashboard page of universal app:

image
image1344×128 5.04 KB

2

@Leo.Shi Could you take a look at this issue?

3

@Bela @rdb Thank you for bringing this to our attention. We are currently investigating the issue and will post an update in this thread as soon as we make progress.

4

Hi @Bela,

We have identified the cause of this issue. It is due to the days() formula column in the Universal App not properly accounting for the Daylight Saving Time (DST) transition in European time zones.

We are working on a fix, and this issue will be resolved in an upcoming release. Thank you again for bringing this to our attention!

5

Thank you very much! And good luck fixing it.