Frontend components need to be aware of "Ignore timezones" flag to send correct dates to API

[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[bot]]

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