Filter by date 'equals' does not work

[phifogg]

Checklist

• [X] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Cloud
  • Tenant ID: foggtest

Describe the bug Filtering on a date column with operator 'equals' does not work.

To Reproduce Within the attached application, do

1. Go to 'Data'
2. Go to table 'datetest'
3. Inspect data rows and see there are two records. There is a date column with 'date only' active. The two records have a date as of Oct 24th and Oct 31st
4. Go to database view 'Filter by date equals'. This filters by date equals Oct 24th. --> Note that no records is shown. Expected is one record.
5. Go to database view 'Filter by date more than'. This filters by date 'equals or more than' Oct 24th --> One record returned (as expected)

Expected behavior When filtering a date column with 'equals' and matching values it is expected to return the correct number of database records.

App Export DateTest-export-1729794038300.tar.gz

Desktop (please complete the following information):

• OS: OSX and Win11
• Browser Firefox

Additional context I tested around and it seems there is some issue with timezone matching. Some date elements seem to convert to my system time (CEST), but the database is storing in in UTC. Hence a parameter for a specific date without hours might be transposed. Maybe this is causing the culprit, but I am not sure on it.

[linear[bot]]

BUDI-8778 Filter by date 'equals' does not work

[ConorWebb96]

Closing as its a duplicate of https://github.com/Budibase/budibase/issues/14836

[ConorWebb96]

Apologies, @phifogg. I closed before reading your additional notes. I'm re-opening it, as your comment here is right. Its quite likely that this is related to timezoning.

I'll have a look at your app now.

~ This seems valid thanks for highlighting this 👍