# Allow "Now" in formulas, but calculate every minute to save costs

**URL:** <https://community.fibery.io/t/allow-now-in-formulas-but-calculate-every-minute-to-save-costs/9644>\
**Category:** Ideas & Features\
**Tags:** formulas\
**Created:** [September 22, 2025, 10:21am UTC](https://community.fibery.io/t/allow-now-in-formulas-but-calculate-every-minute-to-save-costs/9644 "2025-09-22T10:21:53Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 23, 2025, 1:24pm UTC](https://community.fibery.io/t/allow-now-in-formulas-but-calculate-every-minute-to-save-costs/9644/9 "2025-09-23T13:24:19Z")

</div>

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 ☹

---

_[View the full topic](https://community.fibery.io/t/allow-now-in-formulas-but-calculate-every-minute-to-save-costs/9644)._