How is this still not available? This is a fairly basic field and the workarounds haven’t been reliable. I don’t think we should have to pay to upgrade to Ops hub just to schedule a workflow to update a field that should already exist. Please HELP US HUBSPOT 
Please add this!
Please!
yes please!!!
+1
This is honestly so incredibly frustrating and embarrassing.
I run HubSpot for our tech company - we are young and fast and savvy, and the effing looks I get from my team when I say “HubSpot can’t calculate today’s date” is SO painful at this point. They know how simple that function is, and how crucial it is to calculations and workflows. This is just as debilitiating as not being able to sort Deals by Sales Rep, an absolute no-brainer, with radio silence for FOUR YEARS.
FOUR.
YEARS.
I am getting so tired of defending HubSpot, and our choice to invest. I am so, so tired of it.
Add this to a freaking mountain of antagonistic behavior from HubSpot. Ignore your users for YEARS! Hey--make it DECADES, WHY NOT!? Make Karsten Koehler your scapegoat and hide behind him for everything!
We need a native property with the “Today’s Date” field that stores the date of the day, so that we can make time calculations, for example, between the date of the stage that the business entered and “Today’s Date” and so we will have the time that the business is stuck at that stage in real time. And many other possible calculations. I know that in Enterprise I can do an automation every day to fill in this date, but in other licenses this automation is more work, if it had this native field it would help a lot.
**
**Hi all, I’m Rachel from the HubSpot Product team. As part of the ‘create time since/time until properties’ beta, you can now build calculated properties to represent the time between ‘today’ and another date/datetime represented by a property. These properties can be used in filters (lists, CRM index page views), automations (as a filter), and to build reports.
Here is a demo and KB article going into more detail about the feature. You can opt into the beta here.
Looking forward to your feedback!
This is available now.
@Shepp I feel your frustration and I’m with you - this 100% needs to be a native functionality, I’ve been telling everyone I talk to at HubSpot how silly it is to have every user build a workflow or use an app to have access to a today’s date property.
With that said, if you haven’t already, there are two solutions:
1 - doesn’t require ops hub, check here for the today’s date workflow by @stuartbalcombe
2 - also doesn’t require ops hub and uses Tick Tock Today (free version of the app) plus the new sync property functionality, steps here
Consolidating these solutions here since there are a lot of different threads with different approaches over the years, both of these take into account current subscriptions and features.
Why is Hubspot dev team not making this much needed enhancement when the community has been crying out for this for 4 years?
At this point, it honestly seems like they don’t have the capability to
make it happen. It’s just above what they are technically capable of in
terms of coding. I can’t accept any other response with this kind of wait
time.
IF ONLY I was allowed timelines like this in my work… For crying out loud.
Hi Everyone
I wrote the original post on this nearly 4 years ago and its still not a feature 
We do have a simple work around now. The bad news is it requires Operations Hub Enterprise which means for a lot of users this won’t be an option.
Create a “date” property on a core object (the company record is the best place for B2B organisations).
Then create a “scheduled” workflow to run at 00:01 daily. The next step in the workflow is to update your “date” property to the “time of action”. This will run every day and give you a todays date field you can then use in formula fields.
We have used this to create custom SLAs, burndown reports and several other functions.
The main issue is that it makes the activity field quite messy as you have a workflow that runs everyday and puts an entry on the activity feed. So it’s a solution its just not the most elegant solution.
that HubSpot just build this in as a standard feature soon but hopefully this helps until they do.
Still need this feature as few of my client has business case for this, without needed the whole Operation Hub Professional (Enterprise is not needed).
Let’s hope to see this feature in a near future.
****Hi all, I’m Rachel from the HubSpot Product team. As part of the ‘create time since/time until properties’ beta, you can now build calculated properties to represent the time between ‘today’ and another date/datetime represented by a property. These properties can be used in filters (lists, CRM index page views), automations (as a filter), and to build reports.
Here is a demo and updated KB article going into more detail about the feature. You can opt into the beta here.
Looking forward to your feedback!
@rwebb1 Thanks for the update! This is a great development, have opted into the beta and will try it out.
I notice that time since/until properties can’t currently be used in other calculated properties – do you know if that will be a permanent limitation? Or may that change in the future?
Hi @kaious , you’re correct that these properties can’t be used in other calculated properties, and we don’t currently plan on removing this limitation. If you’d be willing to share some examples of how you’d like to use a time since/time until property in a calculated property, that would be helpful!
@rwebb1 an example would be a “time open” field, where we either want to display the time from the start date to today’s date if still open, or if closed, the time from the start date to the close date. Currently we do this using calculation field with an if statement referencing a today’s date field which we’ve created and update via a workflow each day.
@rwebb1 I’d urge you move this feature request upwards. I’m scratching my head why I can’t do this natively in a formula / calculated property on all objects. Resorting to workflows for this is so inefficient.
In my setup I have a scheduled workflow to run at midnight that updates a “Today’s Date” property with today’s date - on every available record on the standard objects for Deal, Company, Contact and a custom Subscription Object.
Here’s a simple usecase for why I need this
On our Subscription object, we track contracts that are prorated for several years at a time, and subscription are flagged active and expired in a “Status” property. If a subscriptions contracted end date is passed today’s date (IF EndDate < TodaysDate) then “Status” should be updated from “Active” to “Expired”.
Another: IF StardDate > TodaysDate THEN Status = “Pending Activation”
This is what Salesforce does really well out out of the box with their custom fields, I have essentially the entire Date&Time formula library you see in Excel available to me when creating custom fields in their system.
@kaious - Thanks for that example! I understand the request. That said, I’m wondering if setting up two properties to do this calculation natively would be an improvement over using the workflow, for your use case. For example:
- ‘Time since open’ property = ‘time until’ property calculating time between Start Date and Today’s Date (using net new functionality that was released)
- ‘Time between Start + Close’ property = ‘time between’ property calculating time between Start Date and Close Date