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

[audrius]

Hi Peter,

came here looking for the solution to now( ) / today( ) date. Any chance this has already been planned and is put on the roadmap?

Thanks a lot!

[olgatrykush]

Hello @audrius! Not yet, but we will discuss this feature requests once again with the team to see if we can give you some more concrete timeframes on when it’s gonna be released

[olgatrykush]

Hello @audrius, we will try to prioritize the development of these functions after releasing Baserow 1.13. I’ll keep you posted on the progress

Here is the issue: Today / Now date in formula (#1251) · Issues · Bram Wiepjes / baserow · GitLab.

[bfranklin]

+1 … my use case is to use this to create a “time ago” or “time since” output where I compare creation date to today and then output it like, “3.5 years ago” or “2 months ago” as we find reading time ago values easier than looking at a date.

I guess without a NOW or TODAY function this is impossible within Baserow, at present, unless I am missing something. Perhaps there is some Unix timestamp ability that might be a workaround?

Given this request is slightly different I created a dedicated post for it here: Time ago / time since formula example for Baserow (aka relative dates)