# Today / Now date in formula **URL:** \ **Category:** Technical Help\ **Tags:** formula\ **Created:** [June 11, 2022, 6:26pm UTC](https://community.baserow.io/t/today-now-date-in-formula/815 "2022-06-11T18:26:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![mahmouds12](https://community.baserow.io/letter_avatar_proxy/v4/letter/m/b5ac83/32.png) [@mahmouds12](https://community.baserow.io/u/mahmouds12)\ **Post date:** [June 11, 2022, 6:26pm UTC](https://community.baserow.io/t/today-now-date-in-formula/815/1 "2022-06-11T18:26:48Z")
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)` ---
**Author:** ![Peter](https://community.baserow.io/user_avatar/community.baserow.io/peter/32/4551_2.png) [@Peter](https://community.baserow.io/u/Peter)\ **Post date:** [June 11, 2022, 10:24pm UTC](https://community.baserow.io/t/today-now-date-in-formula/815/2 "2022-06-11T22:24:01Z")
> [@Date calculation with Formula field](https://community.baserow.io/t/date-calculation-with-formula-field/286/2): > > 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 som… ---
**Author:** ![mahmouds12](https://community.baserow.io/letter_avatar_proxy/v4/letter/m/b5ac83/32.png) [@mahmouds12](https://community.baserow.io/u/mahmouds12)\ **Post date:** [June 12, 2022, 10:56am UTC](https://community.baserow.io/t/today-now-date-in-formula/815/3 "2022-06-12T10:56:14Z")
What about doing it like Airtable, they only refresh the NOW() date when someone views the table or maybe refresh today() date once everyday ---
**Author:** ![audrius](https://community.baserow.io/letter_avatar_proxy/v4/letter/a/848f3c/32.png) [@audrius](https://community.baserow.io/u/audrius)\ **Post date:** [October 5, 2022, 2:15pm UTC](https://community.baserow.io/t/today-now-date-in-formula/815/4 "2022-10-05T14:15:49Z")
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! ---
**Author:** ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)\ **Post date:** [October 7, 2022, 10:54am UTC](https://community.baserow.io/t/today-now-date-in-formula/815/5 "2022-10-07T10:54:07Z")
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 🙌 ---
**Author:** ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)\ **Post date:** [October 11, 2022, 2:53pm UTC](https://community.baserow.io/t/today-now-date-in-formula/815/6 "2022-10-11T14:53:16Z")
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](https://gitlab.com/bramw/baserow/-/issues/1251). ---
**Author:** ![bfranklin](https://community.baserow.io/letter_avatar_proxy/v4/letter/b/59ef9b/32.png) [@bfranklin](https://community.baserow.io/u/bfranklin)\ **Post date:** [November 23, 2022, 6:43pm UTC](https://community.baserow.io/t/today-now-date-in-formula/815/7 "2022-11-23T18:43:38Z")
+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)](https://community.baserow.io/t/time-ago-time-since-formula-example-for-baserow-aka-relative-dates/1778) ---
**Author:** ![MacDarki](https://community.baserow.io/letter_avatar_proxy/v4/letter/m/ea5d25/32.png) [@MacDarki](https://community.baserow.io/u/MacDarki)\ **Post date:** [February 23, 2023, 4:31pm UTC](https://community.baserow.io/t/today-now-date-in-formula/815/8 "2023-02-23T16:31:32Z")
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 example in baserow and i’m trying to convert the formula : **if (field( ‘Closing date’) \> (???) , ‘In progress’, ‘Closed’)** So, I was searching for a formula like TODAY but it seems inexistant. I can’t use “date\_interval()” because it’s a text output and a date output is expected. To bypass the issue, I create a new column with today’s date but it’s not dynamic at all… I’m following issue #1251 that was mentionned by @olgatrykush Thank you for your help ! ---
**Author:** ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)\ **Post date:** [February 23, 2023, 4:45pm UTC](https://community.baserow.io/t/today-now-date-in-formula/815/9 "2023-02-23T16:45:40Z")
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 🙌 ---
**Author:** ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)\ **Post date:** [March 10, 2023, 10:32am UTC](https://community.baserow.io/t/today-now-date-in-formula/815/10 "2023-03-10T10:32:26Z")
@mahmouds12 @audrius @bfranklin @MacDarki we have great news 🙂 The `now()` and `today()` formula functions were added to Baserow, so make sure to test them out!