Today / Now date in formula

[mahmouds12]

Is there anyway I can include Today or Now in a formula?
I want to compare a specific date field to TODAY date, and if it’s in the past I’ll return false.

The syntax I expected was to be like this:
if(date_diff('dd', field('end_date'), today()) > 0, true, false)

[Peter]

Date calculation with Formula field

Hey @ESMP, thanks for jumping into the community No such function for today() currently exists within Baserow. As it turns out, the it’s more complex than what initially meets the eye. There’s a lot more to it, but in a nutshell, it has to do with connecting to other formulas in the database and updating all of the values almost in real-time. You can imagine the sort of lift this would be for databases with hundreds of thousands or millions of records. It’s definitely som…

[mahmouds12]

What about doing it like Airtable, they only refresh the NOW() date when someone views the table
or maybe refresh today() date once everyday