🔦 Feature: Filter Days now uniformly utilizes 'datetime' for all calculations.

[emre1e]

Please confirm if feature request does NOT exists already ?

• I confirm there is no existing issue for this

Describe the usecase for the feature

Current Functionality:
The existing filter displays all entries occurring after the specific date and time:

where(2023-12-05 13:30:00+00:00,ge,today)
In this case, all events after '2023-12-05 13:30:00+00:00' are shown.

Suggested Solution

New Functionality:
The proposed filter will display all entries occurring after the specific date, disregarding the time:

where(2023-12-05 13:30:00+00:00,geDate,today)
With this, all events after '2023-12-05 00:00:00+00:00' will be displayed, irrespective of the time.

Additional Context

Node: v18.18.2
Arch: x64
Platform: linux
Docker: true
RootDB: pg
PackageVersion: 0.202.9-20231204-1203

[dstala]

@emre1e can you help us understand purpose of this change proposal? if we wish to disregard time, is it not good idea to switch over to date type instead of date time?

[emre1e]

@dstala this are appointment and must be in datetime. I have no option to see all appointment from yesterday. Its always using the time too.

Maybe we could create a new formula to convert datetime to date and i can use it in the filter?

[emre1e]

@dstala i think this #7189 fixed it.