Days Until "X" Date

[mimidwest]

Is there a way to populate a custom property with the amount of days until X date. For instance, we want to populate an email with something like "17 Days Until Your Event" where 17 is how many days until their event is scheduled for. 

Thanks for your help.

[DStaat]

Hey @mimidwest,

Have you heard of Tick Tock Today? It's an app that creates a today's date property for your objects. It's available on the HubSpot Marketplace.

You could use this property to create a time between property using today's date and the event's date. There's a blog post going over how to to that here.

 
If you have any questions, feel free to reach out. I'd be happy to hop on a call with you!

Best,

-David Staat

[karstenkoehler · Accepted solution]

Hi @mimidwest,

This can be achieved quite easily with Operations Hub Professional, not so easily without it.

With Operations Hub Professional, you would first create a Today's date property by setting up a contact-based workflow that runs every day at midnight. You would enroll all contacts (Create date is known) and set the value of a date property to the date of the step.

You can then create a calculation property to calculate the duration between this date property and the date property that contains the event date.

When using this property as a personalization token in an email, you'll have to use hubL to convert it to a rounded number by placing typing this instead of placing a personalization token via the UI:

{{ contact.name|int|float|divide(1000)|divide(60)|divide(60)|divide(24)|round }}

Replace the "name" in there with the internal label of your calculation property. (You can find this by navigating to the property settings and clicking the </> sign after opening the property.)

Without Operations Hub Professional this is slighly more finicky as the today's date property can't be created as reliably: https://community.hubspot.com/t5/CRM/How-to-create-a-Today-s-date-date-property/m-p/389836

Best regards!