Having a dynamic 'today' field in the 'Time between' feature

[Achagnon1]

I'm in the process of setting up calculated properties to use the new "time between" feature in reporting, and realized that, in the 'time between' calculations for properties, I'd like to have access to the option 'today,' which would be a dynamic date set as the value of today's date.

That would allow me to track dynamically how long has it been since a deal has been created ('today' minus 'create date' = how far along we are in the sales cycle up till now). 

[SkeeStylus · Accepted solution]

Great news everyone.  Looks like the the excellent work of @rwebb1 and the product team we can now filter, report on, and sort by the time since or the time until an event.  Great addition!  Here's more on the full BETA.  

[DimitriAntoniou]

YES THIS! This would unlock so much value in viewing how long someone has been in their current stage!

[RandyPeterson]

Please add this.

[JoeGlenn]

Our company uses HubSpot and we like it. Their customer service on the
phone has always been excellent. But they seem to have just ignored all of
us on this topic. I've not even seen one response or update from HubSpot.
Maybe I missed it?

[skhristich]

Is there any arrival date when this will be implemented?

[MValleskey]

You can do this, to get you by, but yes this needs to be added: https://community.hubspot.com/t5/CRM/How-to-create-a-Today-s-date-date-property/td-p/389836

[mitch8]

Hi all,

This is way more confusing that it should be!

It's baffling how we cannot report based on a date field matching the date of 'Today'.

I'm trying to build a workflow that will trigger when a customer returns a vehicle. 'Return date' is the property. Is anyone able to simplify how i can use the 'Return date' to kick start my workflow? I'd massively appreciate it!

I'd even be happy for it to trigger based on it being 1 day out as I'd be able to put a delay in to compensate this.

All the best 👍

[LMcFarlane]

This field is essential, please add

[slvale2]

Yes, please add this!

[Bausbrooks]

This would be such a game-changing feature. 

Currently trying to calculate the time left on a trial/subscription for each user and this is impossible without the bloated and mistake-ridden workarounds.

[tannerm123]

Definitely needed, especially the dynamic 'today' part.

Our use-case is sending out a CRS - we only want to send this if the event happened today and they meet other criteria. If the event happened in the recent past and they NOW meet the other criteria, we don't want to send the CRS.

[LMaseraGarza]

I did a workflow workaround to create a "Today's Date" field. Then used that to calculate the "Length of Membership" field. On the contact record it shows, membership is "10 years" but when I put it in the email, it says, "31,708,800,000" because it turns it back to milliseconds!

UGH! What is the reasoning for this? HubSpot is both amazing and extremely frustrating. 😜

[bi_developer]

I've written to the VP of Customer Support twice, and made more than one
support ticket for this request. Hubspot doesn't care and ignores this
thread, but they always respond with a generic "we take your community
requests seriously". The only update to Hubspot I've seen in the past year
is a weak beta feature for events.

[LMaseraGarza]

Please, please implement. We are trying to create a length of membership field and are having to do this outside of HubSpot. 

[GThomson]

something so unbelievably simple yet we still don't have it!

[JPak]

Please make this a priority, HubSpot! It's essential to be able to report on a "today's date" property to track days aging since a specific date or event.

[JulianTEC]

Also trying to do this:

Today's date - Last Activity Date = Days Since Last Activity

[CatherinWright]

Plus one to this ask for a dynamic "today" option for the time between function. Thanks!

[DFrayre2]

Crazy that you can display the "days open" number on deals and tickets, but not report on it or have it reflected in a property. Come on HubSpot! 

[auto-mate]

Harsh but fair!

[GKell]

Another glaring relative date range miss by Hubspot. 

[gsaezsanchez]

More than a year waiting for this feature and no reply from HubSpot so far.