Create a 'Today's Date' field in Hubspot

[Adam-SixandFlow]

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.

[Adam-SixandFlow]

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.

[Adam-SixandFlow]

@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

[Adam-SixandFlow]

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! 

[Adam-SixandFlow]

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

[AMessina]

This would be a huge timesaver and prevent me from needing to export all my sales reports into excel.

[vertika]

This has created problems already! Good that the thread is here at least.

[JLyons0]

That would be a very helpful feature.

[ShanaStagz]

This would be ideal!

[pablorion]

Oh please please add this field.  We have multiple workflows where we need to check the time passed since a property changed state in order to take actions (notify customer, salesteam, etc.)

[DWoods]

Very necessary. Would be great for this simple fix to be prioritized. 

[daskvig]

I need this for calculating the date they started implementation to today's date. Number of days in implementation. Or it could be the number of days as a customer, etc. 

[MBahr]

This small data picker would be extremely helpful for tons of use cases

[eliot_martin]

+1

Every day I find myself on the HubSpot community upvoting ideas that should just be in the vanilla product.

[MTerry0]

This is really needed. It's difficult to manage a service team without knowing the age of an open service ticket

[CaptainSprocket]

Yes please. Today() date field.

[KAgosta]

Agree with all on this thread, and it has been a few years. This function wb applicable in so many ways.

Is it really that difficult to create? What's the issue? 

Please let us know. Keeping users in the dark isn't a great way to cultivate customer trust and loyalty.  😉  

Does anyone on here have some understanding of why this might be particularly difficult?  Perhaps, because of worldwide time zones and different days/dates.

Just grabbing at straws here. 

[Jnix284]

need this for service tickets also, this would be great for all hubs/users

[TJarvis8]

Unbelievable this hasn't been added yet. Really basic feature that's hugely needed.

[Beata_W]

This is kind of basic functionality 😭

[Amevian]

This is fundamental and should have already been a part of the platform. Now, with the addition of Operations Hub, it is even more difficult to create a workaround to accomplish anything surrounding today's date.

[PTamisin]

I can't believe there is a calculated field feature that supports days since, but that Today() not an option.  Please implent this.  Having to use workflows to populate a custom Today field is way too much work for something that should just work.

[CEW]

@hubspot Can you please update this thread on the latest on a "Today's date" property?  Either way, can you please publish something that would outline how to get this done today?  

[David-Perth]

Even the most basic and cheapest CRM's available have this simple function. Even free CRM's offer a today's date property

This would also take the developers almost no time to implement

Not sure why the delay here. Please make this happen!

[06163]

Yes please. This feature is a must. Current solution is clunky and tbh I'm totally surprised it is missing. I have just migrated from another marketing platform which has this feature, and my mind blown that it's not supported in Hubspot.