If I have a Project DB with 1:m relation to Tasks, I might want a formula
Tasks.Filter(Now() > [Due Date])
This is not currently possible.
I’m not sure how this could work with a frontend transformation/formatting solution in a performant way.
And using rules as a solution would rely on updating an editable field, which is not usually desirable.
TLDR there is definitely a need to have more granular date comparisons in formulas than is currently possible i.e. supporting Now() as well as Today()
But I don’t see it getting addressed any time soon 