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)

Today / Now date in formula

formula

Peter June 11, 2022, 10:24pm 2

Date calculation with Formula field Baserow Help

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…

3 Likes

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled