Date calculation with Formula field

Hi everyone! I can’t seem to find a way to make a date calculation using the formula field. I just want to calculate the age of a person but I don’t know how to use today’s date as an argument. Is it possible right now?

Thanks!

Hey @ESMP, thanks for jumping into the community :wave:

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. :sweat_smile:

It’s definitely something we’ve looked into internally though, and hope to have it in the future. :crossed_fingers:

1 Like

Hello @ESMP, that’s now possible to calculate the age of a person in Baserow by using today() formula function which was released in Baserow 1.15.

That is great news!! Thank you very much!