Database date & time text field data is not consistent

Need help Database
1

I have a text field called ‘Date & Time’ to store information for my events in my app (I am using the dd/mm/yyyy date format).

In the database entry it shows the correct time & date of ‘27/11/2023 18:00 - 19:30’.

image
image750×206 8.93 KB

In the app data page, the dates changes by 1 week to ‘4/12/2023 18:00 - 19:30’.

image

Within my app, the date displays correctly (‘27/11/2023 18:00 - 19:30’) some of the time and incorrectly (‘4/12/2023 18:00 - 19:30’) other times.

It is a text field so I don’t know why the value would change like that. Am I missing something? Or is this a bug in Bubble?

3

UPDATE: I had a deleted field in my database called ‘Date & Time’ which was still being referenced in my app.

The fix was to relink my app’s content to the correct ‘Date & Time’ field. In Settings > General, I also used the ‘Optimize application’ button to permanently delete the old ‘Date & Time’ field from my application.