Table Filters for "Less Than or Equal To" on Date/DateTime don't accept "or equal to" values.

[mikesealey]

Checklist

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

Hosting

• Self & Cloud

Describe the bug
When applying a filter to dates the Less than or equal to don't actually pass equal values.

To Reproduce
Steps to reproduce the behavior:

1. Create a table with some dates that include data times
2. Add a form containing date fields, for "start date" and "end date"
3. Add a table component to display the dates
4. use the "start date" and "end date" fields as filters using "Less than or equal to" and "More than or equal to"
5. Filter using an exact date-time that exists in the table
6. Row that equals the date-time passed will be filtered out

Expected behaviour
Filters set this way should be inclusive, (in short "pick a number between 1 & 3" should allow 1,2, or 3, not just 2)

Screenshots

Burger - 07/06/2024 : 00:00 should display as the filter is "Less than or equal to"

Start Date and End date are deliberately identical, and match Lasagna

Start Date is exactly Lasagna's Date Time, End date is 1 minute over

Start Date is exactly Fajitas Date Time but End Date is 59 minutes after Lasagna, but Lasagna doesn't show (Shows at 01:00)

App Export
Comparisons In Filters-export-1718795393168.tar.gz

Desktop (please complete the following information):

• OS: iOS
• Browser Chrome
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

[linear]

BUDI-8379 Table Filters for "Less Than or Equal To" on Date/DateTime don't accept "or equal to" values.