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)

[image] Date calculation with Formula field Baserow Help 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,…

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 impossibl…

Hello everyone ! +1. My use case : I work for a company that want to migrate from Airtable to Baserow. I want to compare the today’s date with a future known date. One column from Airtable is the following formula : IF({Closing date}>TODAY(),‘In progress’,‘Closed’) I migrate a database for an e…

Hello @MacDarki , this feature is under development right now, so now() function should be available to use very-very soon thanks to @davide who is working on it :raised_hands:

@mahmouds12 @audrius @bfranklin @MacDarki we have great news :slightly_smiling_face: The now() and today() formula functions were added to Baserow, so make sure to test them out!

Baserow

Today / Now date in formula

Technical Help

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…

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled