When adding an event to the calendar, the date changes to the day before

User Talk
1

Hello,
I need help with the calendar dates.
When I add an event through a form page. The calendar always changes the date to the day before. The data base as the correct date inserted on the table, but on the calender shows the day before.

Screenshot 2025-03-10 121259
Screenshot 2025-03-10 1212591509×330 18.7 KB

Screenshot 2025-03-10 121316
Screenshot 2025-03-10 1213161610×828 32.5 KB

Screenshot 2025-03-10 121332
Screenshot 2025-03-10 121332810×887 23.5 KB

Thank you in advance.

2

Welcome to the SeaTable forum.

Please specify if use SeaTable Cloud or if you run your own SeaTable instance. If you run SeaTable Server, please specify the version.

3

I use SeaTable Cloud (free)

4

I tried changing the column of the Date, to be set accurate to the minute and it solved it.
So if the event does not have an hour set, he will save it on the day before on the calendar.

5

I think I’m experiencing the same when comparing data in the app vs the base.

For reference I’m using Seatable Cloud and the Calendar and Timeline pages, working in a UK time zone, the dates in the base are ISO format with accurate to minute toggled on.

After a bit of testing, if a user adds or modifies a date in the universal app:

  • The calendar and timeline look as they should
  • The record in the base is correct

But after refreshing the app page:

  • the entry in the calendar and timeline is displayed as the date and time entered -1hr
  • the record in the base is unaffected and remains correct

So if a user modifies or adds a date and the time is set to 00:00 or 00:30, e.g. 2025-03-13 00:00, after refreshing the app page the record will be displayed as 2025-03-12 23:00 which creates confusion for the app user as the incorrect dates can be displayed, even though they are correct in the base.