Today / Now date in formula

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)

1 Like
3 Likes

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

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!

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 :raised_hands:

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 :raised_hands:

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

+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)