HubSpot Ideas

Adam-SixandFlow

Create a 'Today's Date' field in Hubspot

Currently, you have no date property that tells you today's date. This is genuinely a critical function if you are going to compete with other CRMs. How can a sales team set and keep SLAs if they can only look at the time spent in stage retroactively? Please fix it or bring in a "Today's Date" field so people can work around it using a calculated property and some basic automation i.e.

 

  • Enters deal stage > set date picker to "date of entry"
  • Calc field = time between "Date of entry" & "Today's Date"
  • Report = all deals with "Calc field" >7
  • Automation = id "calc field">7 notify salesperson and manager.

 

This is a huge hole in the system and is going to cost your partner's deals. A simple addition like this would unlock a lot of potential within the system.

HubSpot Updates
January 10, 2025 01:54 PM

Hi @Mike_ , I'm wondering if you can set up the logic you describe using time until/time since properties. For example, I created a workflow updating a ‘Status’ property based on the value of a ‘time until subscription end date’ property (both are custom object properties). This workflow automatically updated the Status property when ‘time until subscription end date’ is less than 0 days (as in, the end date is in the past). Here’s a quick screenshot of my workflow setup.

Screenshot 2025-01-10 at 4.31.11 PM.png

January 10, 2025 01:46 PM

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

  1. ‘Time since open’ property = ‘time until’ property calculating time between Start Date and Today’s Date (using net new functionality that was released)
  2. ‘Time between Start + Close’ property = ‘time between’ property calculating time between Start Date and Close Date

January 08, 2025 07:02 AM

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! 

In Beta
January 06, 2025 02:35 PM

 👋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!

93 Replies
rwolupo
Top Contributor

oh yes, i would love that!

 

OliviaB
HubSpot Employee
rwolupo
Top Contributor

oh this sounds nice. Thx @OliviaB 

dhale
Participant

This is certainly a must have more than a nice to have for our team!

LauraGB
Member

Mind blown that this doesn't exist. The absence of this function is all over the "ideas" section, albeit in different posts. I've now spent three weeks working with the support team to attempting to create a workflow that will do this (there is a workflow design posted in the community but unfortunately, it wouldn't work). I am less than delighted that something so basic is not available. Wonder how much time HS has spent in support solving this for many customers over the years - might have been easier to just have the programmers put the function in. I discussed this with my programming team to see if I was missing some complexity that would preclude this. We're baffled as well. I'd be curious to hear why it's not there? It's always tempting to program new things but the basics shouldn't be ignored.

 

TimWheeler79
Participant

To utilize today's date in a workflow is simply foundational to any marketing automation platform.

mrspabs
Top Contributor | Elite Partner

Yep. I don't need a today's date field. I just need for the calculation of date to include today's date as an option when picking the fields! I also need it to calculate SLA. 

ShaiR
Member

This would really be great to have and such a basic funtionality.

RandyPeterson
Participant

There are at least three different threads requesting this basic feature and hundreds of upvotes, but I can't see any response on any of them from HubSpot. Why?

MTBCybermaniacs
Participant

Hubspot. You have to get it together. Your functionality is lacking in so many areas compared to Salesforce. I am crippled without functions like this. Please actually listen to your CRM driven clients and make updates that get a high volume of votes. 

HBaron0
Member

sad they havent built this yet. Hubspot you need to build this...

HarrisonBaron
Participant | Partner

Please create this its been almost 2 years.

JMeeks
Member

This would be a great added feature.

JBowman1
Member

This is sorely needed please make it happen

drittman
Member

This would be very helpful

BPayne1
Member

Sounds good.

ANewmanQx
Member

Much Needed, basic feature!!

Josiah
Member

Agreed!!!

LBall
Member

This would be a nice feature!

JAWS
Member

That would be a grea new and required feature.