NocoBase: Timezone Issue with Date Scope Filter on “Today”

English Forum
1

Hi all,

I’m running the latest version of NocoBase v1.7.14 on Docker. My time zone is New Zealand (Pacific/Auckland), and I’ve configured the environment as follows:

  • Docker environment variable:
    TZ=Pacific/Auckland
  • Mounted timezone files in docker-compose.yml:

/etc/localtime:/etc/localtime:ro
/etc/timezone:/etc/timezone:ro

  • The NocoBase database is MariaDB v11.4, and its time zone is also set to Pacific/Auckland.

Despite these settings, I’m having an issue with the date-based data scope filter (in a table block) set to “Today”.

For example, today is 18 June, but the table shows records from 17 June instead. Interestingly, after 12:00 PM (noon) local time, it starts showing the correct records (18 June).

It seems like the system is calculating “Today” in UTC or using the wrong offset until midday.

Is there another timezone setting I might have missed, either in NocoBase or its frontend/backend logic?

Any help or suggestions would be greatly appreciated.

Regards
Napat

3

Please provide the following information:

  1. What is the specific type of the field in NocoBase?
  2. Screenshot of the data range setting.
4

Hi,

The field interface is set to DateOnly.

image
image383×651 18.1 KB

Today is 19 June, and my local time is 10 AM (before midday). As shown in the screenshot, the records are displaying today’s entries as 18 June instead of 19 June.

image
image949×449 27 KB

image
image940×288 13 KB

Regards
Napat

5

Thanks for the feedback, this is a bug, wait for us to fix it.